How to black out rows or columns in Excel with keyboard shortcuts
The operation of blackening data tables on Excel is already a familiar operation when you work with this office tool. We can use the mouse to black out the entire data. This can also be done when you want to black out a column or row in a data table.
However, in addition to taking the mouse to the beginning of the row or the beginning of the column and then clicking the mouse to highlight it, you can use the keyboard shortcut to manipulate this faster. Shortcuts always support users to perform faster tasks such as when you work on Excel, or work on Word. The following article will guide readers to black out a row or even a column in Excel with a shortcut.
- How to add and edit shortcuts in Word 2013
- MS Excel - Lesson 4: Working with lines, columns, sheets
- How to combine 2 columns Full name in Excel does not lose content
How to black out Excel columns and rows with keyboard shortcuts
Step 1:
We select one cell in the row or column to be highlighted.
Step 2:
We press Shift + SPACE key combination to black out 1 row of selected data. You will immediately see the row of data in the Excel table being blackened as shown below.
If you want to black out the entire column in Excel, press Ctrl + Spacebar .
Step 3:
To black out the entire table , after pressing Shift + key to blacken the row, press Ctrl + spacebar to black out the column. Thus the whole table will be blacked out, similar to Ctrl + A.
Note in case the user wants to black out some lines in the whole table, click on the first line (click the line number to select the starting line), then hold down Shift and drag down to the line with number of things you want to blacken.
Here I will click on number 1 and hold down Shift and drag down the scroll bar to blacken, for example line 4 will add 4R order as shown. If the first line is not 1 then you must add it yourself.
A very simple trick, but it helps you a lot when you have to handle multiple files, or various Excel data tables. We only need to perform keystrokes to quickly blacken rows or columns in Excel. Save shortcuts for quick blackening of rows or columns to shortcuts on Excel to make it easier to work.
See more:
- These are the most basic functions in Excel that you need to understand
- Forgot password protected Excel file, what should you do?
- How to reopen Word, Excel or PowerPoint files when closed but not saved yet?
Hope this article is useful to you!
You should read it
- How to delete, add columns in Excel
- MS Excel - Lesson 4: Working with lines, columns, sheets
- Steps to lock columns in Excel
- How to number columns automatically in Excel
- How to keep Excel and Excel columns fixed?
- 2 ways to separate column Full and Name in Excel
- 14 time-saving tips when using Microsoft Excel
- Instructions for separating column content in Excel
- Ways to hide data on Excel
- Insert line shortcut in Excel - Shortcut insert Excel
- The way to color alternating columns in Excel is extremely simple
- Shortcut guide, abbreviated in Excel
Maybe you are interested
Excel 2016 - Lesson 12: Formatting pages and printing spreadsheets in Excel
How to turn off auto formatting in Excel
Here's What to Do Before Sharing an Excel Spreadsheet
How to use the TREND function in Excel
How to create Progress Bar in Excel, conditional progress bar
How to change auto save time on Excel, Auto Save Excel File