How To Unhide Rows In Excel For Mac Bug
- egoryudin365
- Apr 13, 2021
- 3 min read
If you later want to unhide column A, the solution isn't so obvious To unhide the left-most columns of a worksheet when they are hidden, follow these steps: • Choose Go To from the Edit menu, or press F5.. Selecting a cell in the spreadsheet, choose Table, again both options to unhide are greyed out Selecting row above or below and clicking drop-down next to row number, no option available to unhide, only to hide that row.. Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums.. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site.. Excel displays the Go To dialog box [SOLVED] Can't Unhide rows? Results 1 to 6 of 6 Can't Unhide rows? LinkBack URL; About LinkBacks; Thread Tools.. You have to go to the edit menu by pressing f5 then type in the column you want to unhide press ok, then go to the format menu and do what was said to do.. • Choose Column from the Format menu, then choose Unhide Another way to display the first column is to click on the header for column B, and then drag the mouse to the left.. Your previously missing column A magically reappears Ok it works for excel 2010 do exact what he said and when you go to the format menu scroll down to hide/unhide and select unhide columns and you will have what ever column you chose in the edit menu back.. If you move your mouse pointer into the column header area, and then slowly move it to the left, you notice that it turns into a double-headed arrow with a blank spot in the middle as you position the pointer over the small area immediately to the left of the column B header.. So, if you chose A1 then A1 will come back You cant skip the edit menu and go straight to the format menu and try to unhide it wont work.. All postings and use of the content on this site are subject to the. Show Printable Version Excel 2010 Posts 788 Can't Unhide rows? I am trying to unhide rows but the Unhide command is not allowing me to? I have selected the entire worksheet and highlighted the rows.. Selected everything (command-a), no unhide options available in any menu Removed 'freezing' from column and row headers I'm guessing it's something basic but it's well 'hidden' at least from me.. When your mouse pointer changes to this special double-headed arrow, all you have to do is right-click and choose Unhide.. For instance, if you hide column A, Excel will dutifully follow out your instructions.. This double-headed arrow is a bit difficult to describe; it looks most closely like the double-headed arrow that appears when you position the pointer over the dividing line between column headers.. You can then choose Column from the Format menu and then choose Unhide A third method is even niftier, provided you have a good eye and a steady mouse pointer.. It is different, however, because instead of a black line dividing the double arrows, there are two black lines with a gap between them.. Nov 12, 2018 - Learn how to use shortcut keys or the context menu to hide and unhide columns and rows in Excel for better spreadsheet management.. If you release the mouse button when the pointer is over the gray block that marks the intersection of the row and column headers (the blank gray block just above the row headers), then column B and everything to its left, including the hidden column A, are selected.. (See Figure 1 ) Figure 1 The Go To dialog box • In the Reference field at the bottom of the dialog box, enter A1.. I hid some rows in a spreadsheet but am unable to unhide them I've tried: Selecting row above or below hidden rows, choose Table menu, both options to unhide are greyed out.. • Click on OK Cell A1 is now selected, even though you cannot see it on the screen.. Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only.. I've used spreadsheet programs (primarily Excel) for years Just recently started with Numbers.. Excel makes it easy to hide and unhide columns What isn't so easy is displaying a hidden column if that column is the left-most column in the worksheet. d70b09c2d4
Comments