HomeHow toHow to hide columns and rows in Excel

How to hide columns and rows in Excel

If your Excel spreadsheet has data that can’t be deleted, but you don’t want it to appear or have the same prominence as the others, a good option is to hide that information. To do this, see how to hide Excel columns and rows quickly and easily, and also learn how to redisplay them when needed.

- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

How to hide columns and rows in Excel

Here’s how to hide columns (steps 1 and 2) and how to hide rows (steps 3 and 4) in Excel, whether on Windows, macOS, or via the web:

Total Time: 2 minutes

Select the columns you want to hide:

To select a column, click on its corresponding letter, located at the top of the column. To select multiple columns that are next to each other, click on the letter of the first and drag the cursor over the others. To select multiple columns that are not next to each other, click on the letter of one of them and hold down the Ctrl key while clicking on the letters of the others;

- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

Hide the column:

Selected the columns, right-click on any of their corresponding letters (located at the top of the columns) and click the “Hide Columns” option. Ready, automatically the selected columns will be hidden;

Select the lines you want to hide:

To select a line, click on its corresponding number, located to the left of the line. To select multiple lines that are next to each other, click on the number of the first and drag the cursor over the others. To select multiple lines that are not next to each other, click on the number of one of them and hold down the Ctrl key while clicking on the numbers of the others;

Hide the line:

Selected the lines, right-click on any of their matching numbers (located to the left of the lines) and click the “Hide Lines” option. Ready, automatically the selected lines will be hidden.

How to redisplay a column or row that has been hidden

Even if you didn’t hide an Excel column or row, notice that it’s easy to find out if there are elements like this in an editor file, as the letter or number corresponding to it disappears, leaving its alphabetical or numerical order incomplete. Also, where the column or row was hidden, the grid line (the row that separates cells from a worksheet and has a more subtle tone) becomes double.

Given this information, there are two ways to redisplay an Excel column or row (which may vary depending on the editor you use). For the first, do the following:

- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

  1. Select the columns or rows adjacent to the element that was hidden;
  2. Right-click on the letter (for column) or number (for row) of one of them and click the “Redisplay Columns” or “Redisplay Rows” option.

Another option to redisplay this data is to follow the steps:

  1. Stop the mouse over the double grid line that formed where the data was hidden and notice that the cursor appears with a split in which there is an arrow for each of its sides;
  2. Drag the cursor slightly to the side where the column or row was hidden (still keeping its view with the arrows) and click its letter or number so that the element is displayed again.
- Advertisement -

Trade Gift Card With Legit Chinese Vendor on WhatsApp

George Philip
George Philiphttps://betechwise.com
George Philip is a seasoned tech professional with a deep-rooted passion for all things tech-related. His mission is to demystify complex tech topics and provide you with the insights and knowledge you need to navigate the ever-changing world of technology. With a keen eye for detail and a talent for making the intricate seem simple, George crafts engaging content that explores how technology impacts your daily life, your workplace, and the broader global landscape. Whether you're eager to stay updated on the latest gadgets, intrigued by emerging tech trends, or simply looking to understand how digital innovations shape our world, George's writing is your trusted source for clarity and expertise. Feel free to reach out to George via email at [email protected] for inquiries, collaboration opportunities, or to engage in thought-provoking discussions about the fast-paced world of tech. Stay informed, stay connected, and let George be your guide in the tech-savvy universe.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.

- Advertisment -

Most Popular

-Advertisement-spot_img

RECENT POST