Microsoft for mac excel unhide rows

broken image

That indicates one of more hidden row or column. Hidden rows or columns have a double line in the row/column list One reason to hide a row or column is so you can take a quick screen image of a summary without the intervening columns. Now the month and total columns appear beside each other. Go to Home | Cells | Format and select Hide & Unhide | Hide Rows. More on unhiding below but for the moment …: to unhide just add the Shift key:Ĭontrol + Shift + 0 – unhides a column. Select the columns or rows, right-click and choose Hide.

broken image

Hidden rows/columns still work in calculations, they can be referenced in formulas etc. Make your worksheets look more compact and focused by hiding unwanted columns or rows. Thanks for joining us! You'll get a welcome message in a few moments.