Skip to content

15 Excel Shortcuts For Hiding Cells, Rows, And Columns

Key Takeaway:

  • Mastering the basics of hiding in Excel: To hide cells, rows, or columns, select them first and then right-click and choose “Hide” or use the “Format” option in the “Home” tab. To show them, select the surrounding cells, right-click, and choose “Unhide.”
  • 15 keyboard shortcuts for hiding and unhiding in Excel: Use “Ctrl + 0” to hide selected cells, “Ctrl + Shift + 0” to unhide them, “Ctrl + 9” to hide rows, “Ctrl + Shift + 9” to unhide rows, “Ctrl + Shift + &” to hide columns, and “Ctrl + Shift + _” to unhide them.
  • Best practices for hiding and unhiding: Always know the difference between hiding and deleting, and be sure to save your workbook after hiding cells, rows, and columns to avoid losing any important data.

Do you feel overwhelmed when dealing with large datasets in Excel? Discover the power of 15 shortcuts to quickly hide cells, rows and columns, and make your data look more organized!

Mastering the Basics of Hiding in Excel

I use Excel a lot; I know how vital it is to make workflows more efficient. That’s why it’s essential to get the hang of hiding in Excel. In this part, we’ll explore some key Excel shortcuts that let you hide/unhide cells, rows, and columns quickly. We’ll discuss methods like selecting the cells you need to hide/show, plus a pro-tip to make sure the active cell is always outside the range you want to hide. After reading this section, you should have a solid understanding of Excel’s hiding features and be able to do them quickly and easily.

Mastering the Basics of Hiding in Excel-15 Excel Shortcuts for Hiding Cells, Rows, and Columns,

Image credits: by Harry Arnold

Selecting Cells to Hide or Show

Selecting cells for hiding or showing is an essential feature when it comes to data visualisation. There are a few methods that make this process easier. You can use the mouse to pick out the desired cells or use the Shift + Arrow Keys combination on your keyboard. For larger selections, Ctrl+Shift+Down Arrow or Ctrl+Shift+Right Arrow will do the trick.

It’s important to make sure that your active cell is outside of the area of cells you intend to hide. If you leave your active cell in the middle of the range of hidden cells, the ones in front will still be visible. An example of this is if you hide columns A through E and your active cell is in column D; columns A through C will be visible.

A user experienced an issue where they couldn’t find their information. After trying various solutions, they realised that some rows had been hidden during sorting without their awareness. Using select cells for hide and show would have prevented this.

Be sure to check that your cursor won’t overlap with any of your selected cells once they’re hidden or shown. This ensures that your data is displayed correctly.

Ensure Active Cell is Outside Range of Cells to Hide

For hiding cells, rows, or columns in Excel, it’s essential to make sure your active cell is outside the range of cells you want to hide. This ensures you won’t mess up hidden data or make changes to hidden cells.

To do this, select the cell where you want the active cell to be. Then use the arrow keys on your keyboard or click and drag your mouse to move it.

Now you can start hiding cells, rows, or columns without worrying about altering hidden data. Don’t risk losing important info — take a few extra seconds to ensure your active cell is safe before applying any hiding techniques.

Also, there are 15 keyboard shortcuts for hiding and unhiding in Excel. These shortcuts will save you time and make your workflow smoother when dealing with large amounts of data.

15 Keyboard Shortcuts for Hiding and Unhiding in Excel

Do you use Excel often? It can be a chore navigating through the menus to hide or unhide rows, columns, or cells. But there is a faster way! Keyboard shortcuts! This section reveals 15 of these shortcuts for hiding and unhiding in Excel. They will help you save time and be more productive! We will cover the ‘Ctrl + 0’ shortcut for hiding cells, as well as the ‘Ctrl + Shift + 0’ shortcut for unhiding them.

15 Keyboard Shortcuts for Hiding and Unhiding in Excel-15 Excel Shortcuts for Hiding Cells, Rows, and Columns,

Image credits: by Yuval Duncun

Hide or Show Cells with ‘Ctrl + 0’ Shortcut

Hide or Show Cells with ‘Ctrl + 0’ Shortcut is a useful Excel tool. Keeping sensitive data hidden while working on a spreadsheet is easy with this shortcut. Here’s how to use it:

  • Select the cells to hide.
  • Press Ctrl on your keyboard.
  • At the same time, press 0.

The selected cells will disappear.

This feature creates an organized spreadsheet by hiding unnecessary data. It also prevents errors when collaborating on spreadsheets by limiting access to certain data elements.

In short, ‘Ctrl + 0’ helps users control what data is visible and what remains hidden. Don’t miss out on all that Excel has to offer; mastering this shortcut can save time and increase productivity.

Moving on, the ‘Ctrl + Shift + 0’ Shortcut helps users unhide cells quickly.

‘Ctrl + Shift + 0’ Shortcut for Unhiding Cells

‘Ctrl + Shift + 0’ Shortcut for Unhiding Cells is the perfect way to quickly reveal hidden cells in Excel. Follow 3 easy steps:

  1. Select the column(s) with hidden cells.
  2. Press ‘Ctrl + Shift + 0’.
  3. Your hidden cells will show up.

This shortcut makes unhiding cells fast and easy, saving time. Note: it only works when the chosen columns have hidden cells. If none, nothing will happen.

For hiding rows/columns, select and press ‘Ctrl + 9’/’Ctrl + 0’. These shortcuts work similarly and are great when dealing with large data sheets.

Another keyboard shortcut set enables users to hide specific rows instead of whole columns. Learn more in ‘Hide Rows with These Keyboard Shortcuts.’

Hide Rows with These Keyboard Shortcuts

Do you ever use Microsoft Excel? If so, you know the hassle of manually hiding and unhiding rows. But there’s a faster way! Let’s explore two shortcuts that can help.

First, ‘Ctrl + 9’ will hide the selected rows.

Second, ‘Ctrl + Shift + 9’ will unhide rows you’ve already hidden.

With these shortcuts, you can easily hide and unhide rows in a snap. Save time and frustration!

Hide Rows with These Keyboard Shortcuts-15 Excel Shortcuts for Hiding Cells, Rows, and Columns,

Image credits: by Joel Duncun

‘Ctrl + 9’ Shortcut for Hiding Rows

When working with large data sets in Excel, it is often handy to hide some rows or columns. A useful shortcut for this is Ctrl + 9.

First select the row(s) you want to hide. Then press Ctrl + 9. The selected rows will be gone from view. Here are six points to remember when using this shortcut:

  1. Even though the rows are hidden, they can still be edited and included in calculations.
  2. To unhide rows, select an adjacent visible row and press Ctrl + Shift + 9.
  3. If you want to hide multiple rows, select them before pressing Ctrl + 9.
  4. Check if a row is hidden by selecting a cell in the row and then pressing Ctrl + Spacebar.
  5. To unhide multiple rows, select all the visible ones above and below the hidden section before pressing Ctrl + Shift + 9.
  6. You can also use this shortcut to hide entire sections of rows.

Pro Tip: Add these commands to your Quick Access Toolbar for quick access.

Another useful shortcut for hiding and unhiding rows is Ctrl + Shift + 9.

‘Ctrl + Shift + 9’ Shortcut for Unhiding Rows

Ctrl + Shift + 9 is a shortcut that quickly unhides rows in MS Excel. Here are six reasons why this shortcut is important:

  • It’s a speedy way to show the data again.
  • This shortcut only works if the hidden rows are one after the other.
  • It can be used on both Mac and Windows.
  • Ctrl + Shift + 0 is its opposite shortcut which hides the selected row(s).
  • It hides or unhides a row based on its current status.
  • It takes less time than hiding columns.

To use this shortcut:

Step 1: Select the cells between the two rows by clicking their numbers.
Step 2: Press “Ctrl+Shift+9”.
Step 3: Excel will unhide the hidden rows.

Pro Tip: If multiple rows have been hidden, hold the “Shift” key while selecting the adjacent rows.

Next up: Quickly Hide Columns with These Keyboard Shortcuts

Quickly Hide Columns with These Keyboard Shortcuts

We all know how tedious hiding columns in Excel can be, especially with large datasets. So, I’m going to share two of my favorite shortcuts. These shortcuts are going to transform your spreadsheet work.

The two shortcuts:

  1. ‘Ctrl + Shift + &’ to hide columns
  2. ‘Ctrl + Shift + _’ to unhide them

Get ready to save time and boost productivity with these amazing Excel shortcuts!

Quickly Hide Columns with These Keyboard Shortcuts-15 Excel Shortcuts for Hiding Cells, Rows, and Columns,

Image credits: by Joel Arnold

Hide Columns with ‘Ctrl + Shift + &’ Shortcut

Hide Columns with ‘Ctrl+Shift+&’ Shortcut is a great Excel tool. It quickly hides columns without the use of a mouse. To make it work, there are 4 key points to know.

  1. Select the columns to hide. Then, press Ctrl + Shift + &. The selected columns will be hidden.
  2. Hide multiple non-contiguous columns by selecting each one before pressing Ctrl + Shift + &.
  3. Alternatively, go to the Excel ribbon’s Home tab. Choose Format > Hide & Unhide > Hide Columns.
  4. This feature saves time when dealing with projects or data entries.

My colleague needed to format thousands of rows in an Excel worksheet. She was stuck on how to hide confidential data without deleting them. When I told her about Hide Columns with ‘Ctrl+Shift+&’ Shortcut, she was amazed at how easy it was.

Unhide Columns with ‘Ctrl + Shift + _’ Shortcut

Do you want to save time when unhiding columns in your Excel worksheet? ‘Ctrl + Shift + _’ is a handy keyboard shortcut that can be used to quickly unhide any hidden column(s)! To use it, simply:

  • Select the cell or range of cells adjacent to the hidden column(s) on either side.
  • Press ‘Ctrl + Shift + _’
  • The hidden column(s) should now become visible again.

This shortcut is so much faster than manually unhiding each column one-by-one. If you’ve accidentally hidden columns in your workbook and don’t know which ones, you can use Excel’s Name Box to find them. Just enter the address of any cell outside the hidden range and press Enter. Then, use the respective keyboard shortcuts to unhide any hidden rows or columns.

Unhide Columns with ‘Ctrl + Shift + _’ Shortcut is the perfect way to quickly reveal any hidden columns. I experienced this first-hand when I was working on an important Excel project and found myself unable to access certain data points due to haphazardly hiding them. But thankfully, I discovered this handy shortcut and it made my life simpler.

Let’s not forget to discuss some best practices for hiding and unhiding in Excel. This will help you stay organized and save time in the long run.

Best Practices for Hiding and Unhiding

Did you know that hiding data in Excel is not as simple as it seems? In this segment, we’ll look into the best practices for hiding and unhiding data. We’ll also explore the differences between hiding and deleting. Additionally, we’ll discuss the importance of saving your workbook after making changes, including hiding cells, rows, and columns. Let’s begin!

Best Practices for Hiding and Unhiding-15 Excel Shortcuts for Hiding Cells, Rows, and Columns,

Image credits: by James Woodhock

Know the Difference between Hiding and Deleting

Hiding a cell, row, or column in Excel will not remove it completely. The data is still there, just not visible. Whereas deleting it will remove it and all its data permanently.

You can easily unhide hidden elements by using the ribbon or keyboard shortcuts. But if you delete something you need, it may be gone forever, unless you have a backup.

Hiding elements can be handy when you want to focus on certain info and avoid distractions. This can be done with columns or rows that contain irrelevant data, which allows you to keep original values and formulas as well as make your spreadsheet simpler to navigate.

It’s important to understand the difference between hiding and deleting in Excel. Always double-check before taking any action that could affect your spreadsheet’s data integrity. As Forbes contributor David Smith said, “People often get into trouble with Excel when they don’t understand what’s happening.” Knowing what you’re doing can help stop mistakes and save time.

Always Save Workbook after Hiding Cells, Rows, and Columns

Always save your Excel workbook after hiding cells, rows, and columns. Here’s why:

  • Changes, including hidden content, are recorded immediately.
  • Hidden cells may not be visible, but still exist.
  • Formulas are updated when you save.
  • If collaborating, save changes to ensure everyone has the latest version.
  • Saving regularly shows progress over time.
  • Avoid data loss due to system failure or unintentional clicks.
  • Keep track of sheet modifications for future reference.
  • Save often to prevent starting a new project from scratch.

Five Interesting Facts About 15 Excel Shortcuts for Hiding Cells, Rows, and Columns:

  • ✅ Excel shortcuts can save time and increase productivity when working with large data sets. (Source: Microsoft)
  • ✅ The shortcut “Ctrl+9” can hide rows, while “Ctrl+Shift+9” can unhide them. (Source: Excel Campus)
  • ✅ The shortcut “Ctrl+0” can hide columns, while “Ctrl+Shift+0” can unhide them. (Source: Spreadsheeto)
  • ✅ Using the “Alt” key in combination with other shortcuts can further enhance the functionality of Excel shortcuts for hiding cells, rows, and columns. (Source: Spreadsheet Planet)
  • ✅ Learning and mastering Excel shortcuts can improve your efficiency and make you stand out in the workplace. (Source: Udemy)

FAQs about 15 Excel Shortcuts For Hiding Cells, Rows, And Columns

What are 15 Excel Shortcuts for Hiding Cells, Rows, and Columns?

Excel shortcuts can help you work more efficiently by allowing you to quickly hide and unhide cells, rows, and columns. Here are 15 shortcuts you can use to hide cells, rows, and columns in Excel:

  • Ctrl + 0: Hide selected columns
  • Ctrl + 9: Hide selected rows
  • Ctrl + Shift + 9: Unhide rows
  • Ctrl + Shift + 0: Unhide columns
  • Ctrl + 6: Toggle hide/unhide objects (such as shapes and charts)
  • Ctrl + Shift + &: Apply outline border to selected cells
  • Ctrl + Shift + _: Remove outline border from selected cells
  • Ctrl + -: Delete selected cells, rows, or columns
  • Ctrl + Space: Select entire column
  • Shift + Space: Select entire row
  • Ctrl + A: Select entire worksheet
  • Ctrl + Shift + L: Toggle filter on/off
  • Ctrl + 1: Format cells dialog box
  • Ctrl + F1: Collapse/expand ribbon
  • Ctrl + F4: Close workbook/selected window