Excel with hidden lines - How to hide lines and display hidden lines in Excel
Sometimes in the process of working, processing data in Excel, you need to hide / show the line in Excel. If you do not know how to hide lines and display hidden lines in Excel, please refer to the following article.
Excel with hidden lines - How to hide lines and display hidden lines in Excel Picture 1
Here's how to hide rows, show hidden lines in Excel, and how to hide / show columns in Excel invite you to follow.
How to hide lines in Excel
Step 1: Select the line to hide.
If you only need to hide one line, then click on the number before that line.
Excel with hidden lines - How to hide lines and display hidden lines in Excel Picture 2
If you want to hide multiple rows in a row, then you select the first line to be hidden, then you hold down the mouse and drag down the other lines to be hidden.
Excel with hidden lines - How to hide lines and display hidden lines in Excel Picture 3
If you want to hide multiple lines separated (non-consecutive), then you select the first line to be hidden, then hold down Ctrl and select the other lines to be hidden.
Excel with hidden lines - How to hide lines and display hidden lines in Excel Picture 4
Step 2: Right-click on the lines you have selected and select Hide to hide the lines.
Excel with hidden lines - How to hide lines and display hidden lines in Excel Picture 5
So the lines you choose will be hidden.
Excel with hidden lines - How to hide lines and display hidden lines in Excel Picture 6
How to display hidden lines in Excel
Step 1: Select (black out) consecutive lines of hidden lines (lines above and lines below the hidden lines).
Excel with hidden lines - How to hide lines and display hidden lines in Excel Picture 7
Step 2 : Right-click on the selected lines and choose Unhide to show hidden lines.
Excel with hidden lines - How to hide lines and display hidden lines in Excel Picture 8
Or if you want to display a hidden line, right-click on the hidden location and select Unhide .
Excel with hidden lines - How to hide lines and display hidden lines in Excel Picture 9
Similarly, you can hide the column and display the hidden column as follows:
1. Hide columns in Excel
Select the columns to hide, then right-click the selected columns and choose Hide .
Excel with hidden lines - How to hide lines and display hidden lines in Excel Picture 10
2. Show hidden columns in Excel
Select adjacent columns (the previous column and the column after the hidden columns), right click and select Unhide .
Excel with hidden lines - How to hide lines and display hidden lines in Excel Picture 11
Above the article has shared with you how to hide lines and display hidden lines in Excel, hope the article will help you. Good luck!
You should read it
- Spacing lines in Excel
- 4 basic steps to color alternating lines in Microsoft Excel
- Instructions on how to create diagonal lines in Excel box
- How to fix non-unhide error in Excel
- Instructions for adding alternate blank lines on Microsoft Excel
- How to indent the line in Excel
- MS Excel - Lesson 4: Working with lines, columns, sheets
- How to fix multiple lines in Excel
- Excel Can't Get New Lines, What Should I Do?
- How to automatically wrap lines in Excel (Wrap Text in Excel)
- Diagonal lines in a cell in Excel
- Adding 1 or more blank lines in Excel is extremely fast
May be interested
Offset function in Excel - Usage and examples
How to combine IF, AND and OR functions to filter data
The search function satisfies many conditions in Excel - Usage and examples
How to show the ruler in Word 2010 and the rule bar in Word 2010
How to display rules in Word 2013 and 2016 - How to display rule bars in Word 2013 and 2016
Spacing lines in Excel