Excel tutorial shortcuts to hide unhide rows and columns exceljet. Step 2 press the shortcut keyboards of ctrl shift down arrow, and then you select all rows beneath working area 24 apr 2013. How to create a powerpivot in excel 2016 for mac pdf. Excel brings back the hidden B column, and all three columns (A, B, and C) are selected. You can then click the mouse pointer on any cell in the worksheet to deselect the columns. You could also unhide column B by selecting columns A through C, right-clicking either one of them, and then choosing the Unhide command on the column shortcut menu. Maybe they're not hidden, perhaps they are just very narrow. Select these columns and a couple of columns either side and reset the column width to 8.43 Mike 'William' wrote: It is not protected. 'Jacob Skaria' wrote: Check whether the sheet is protected.ToolsProtection If this post helps click Yes --------------- Jacob Skaria 'William' wrote: I have several hidden columns (F through K) that I am unable to unhide. I've tried selecting the entire worksheet, but Window/Unhide is grayed out. I've tried only selecting columns E through L but Unhide is still grayed out. Select at least one column to the left and one column to the right of the column you are trying to unhide and then from menu FormatColumnUnhide --Check whether it is really hidden or the column width is set to a small value small.Selecting adjusant columns to left and right and use FormatColumnWidth and set that to 10.and see --Have you applied WindowFreeze panes. If so just try turning that Off If this post helps click Yes --------------- Jacob Skaria 'William' wrote: It is not protected. 'Jacob Skaria' wrote: Check whether the sheet is protected.ToolsProtection If this post helps click Yes --------------- Jacob Skaria 'William' wrote: I have several hidden columns (F through K) that I am unable to unhide. I've tried selecting the entire worksheet, but Window/Unhide is grayed out. I've tried only selecting columns E through L but Unhide is still grayed out. Sharing is essentailly a type of protection. Jim Thomlinson 'William' wrote: It is not protected. 'Jacob Skaria' wrote: Check whether the sheet is protected.ToolsProtection If this post helps click Yes --------------- Jacob Skaria 'William' wrote: I have several hidden columns (F through K) that I am unable to unhide. I've tried selecting the entire worksheet, but Window/Unhide is grayed out. I've tried only selecting columns E through L but Unhide is still grayed out. Resetting the column widths as you suggested did indeed make the columns visible. However, they originally disappeared from view by selecting the columns and then Window/Hide, so it would seem that were hidden. ![]() Whatever, though.. You solved my problem, thanks. 'Mike H' wrote: Maybe they're not hidden, perhaps they are just very narrow. Select these columns and a couple of columns either side and reset the column width to 8.43 Mike 'William' wrote: It is not protected. 'Jacob Skaria' wrote: Check whether the sheet is protected.ToolsProtection If this post helps click Yes --------------- Jacob Skaria 'William' wrote: I have several hidden columns (F through K) that I am unable to unhide. ![]() I've tried selecting the entire worksheet, but Window/Unhide is grayed out. I've tried only selecting columns E through L but Unhide is still grayed out.
0 Comments
Leave a Reply. |