24 окт. 2022 г. · Click the triangle button above the row number 1. This selects all cells. On the Home tab of the ribbon, in the Cells group, select Format > Hide & Unhide > ...

6 февр. 2012 г. · I cannot use several features in Excel 2010, including "Format Cells" and "Add/Delete Row/Column". These options are greyed out as if the sheet was locked.

2 июн. 2023 г. · If the formatting options are greyed out on a protected sheet in Excel, despite having the "Format Cells" option checked off. Please do this:

3 авг. 2014 г. · 1. CTRL+A to select entire worksheet. · 2. Right click on any row number and take unhide. · 3. Right click on any column number and take unhide.

19 мар. 2024 г. · Try selecting all cells using the square to the left of column A and above row 1, then right-click a row number and set the row heights to say 15.

18 мая 2018 г. · I'd suggest doing an online repair of the installation. The instructions to follow to do this are here: https://support.office.com/en-us/article ...

4 мар. 2022 г. · Try to click in a cell and then press Ctrl + End. That will take you to what Excel thinks is the last cell of data. Or Go to last cell in column A containing ...

15 февр. 2012 г. · If the Unhide button in the Window group is enabled, click it. Is the workbook listed? If so, select it and click OK. Does that solve the ...

6 авг. 2023 г. · 1. First, make sure that the fill handle is enabled by going to File > Options > Advanced and checking that "Enable fill handle and cell drag-and-drop" is ...

4 окт. 2023 г. · I've tried to unlock the sheet to see if I had made a mistake by having the cell locked but I cant, the unprotect sheet is grayed out.