Buzz
Answer:
Hello, to hide or unhide rows and columns in Excel 2013, follow these steps. Feel free to ask if you need further assistance.
1. Hiding rows:
Step 1: Select the rows you want to hide, you can choose one or multiple rows. Then right-click and select Hide.
Step 2: When rows are hidden, a bold line appears. However, this line disappears during actions.
2. How to show rows
Select the row below the hidden rows, right-click, and choose Unhide.
Result: A green border appears around the restored rows.
3. How to hide columns
Step 1: Select the columns you want to hide, you can choose one or multiple columns. Right-click and choose Hide.
Step 2: When columns are hidden, a bold line appears. However, this line disappears during actions.
4. How to show columns
Select the columns to the left and right of the hidden column, right-click and choose Unhide
Result: The hidden columns will be displayed.
- Attention
- Hidden rows or columns still contribute to your calculations. All content, including headers, will be hidden. You can hide or show multiple columns at once by selecting all the columns and rows you want to hide.
Similarly, on Office 2003, Excel 2007, and Excel 2010, you can also perform the same actions.
