Drawing on a few Microsoft Excel keyboard shortcuts, you won’t have to spend time with your mouse as much and as a bonus, you’ll also save time.
We all want to make our time at work efficient and take fewer breaks, which is why learning ways to do small tasks quicker is always a win. Of course, you can use keyboard shortcuts in each of the Office apps to reduce your workload and make it more convenient.
This article provides a side-by-side comparison of Microsoft Office 365 and Google G Suite. Complete with a checklist, it’ll help you decide which one is the best choice for your organization’s needs.
Pretty much everyone knows how to do something on a Microsoft Excel sheet. Let me show you some quick keyboard shortcuts that will maximize your productivity when working with rows and columns.
Excel is a great tool for busy professionals. Whether you’re on the go, or a desktop user, you can stay productive with InteliJect’s suite of applications. Plus, Excel supports common keyboard shortcuts.
Top 11 Excel keyboard shortcuts
How to select the current row in Excel:
Sometimes there are multiple ways to select a row. I like clicking the header cell, but if you’re near the top or bottom of a long table and need to select more than one row, clicking the top-left or bottom-right corner of a cell in the row is effective. Try Shift+Spacebar to select any given row.
By header cell, I mean the column of numbers to the left of column A. The figure shown in Figure A is an example of this.
You can select a row by clicking its header cell. Use the Shift + Spacebar keys to select an entire column, if it’s quicker for you.
You can select an entire row with the header but Shift + Spacebar may be quicker.
Use this keyboard shortcut to select multiple rows. If you’ve selected cells C4:C12, pressing Shift + Spacebar will select rows 4 through 12. The selection must be contiguous.
Column selection on a spreadsheet in Excel
You can select an entire column just like you would select a row. To choose an item in a selection that’s not available, press Ctrl + Spacebar to select the start of the selection. If a contiguous selection comprises multiple columns, press Ctrl + Spacebar to select the beginning of the contiguous column instead.
The quick way to delete the current row in Excel
If you have a selection of rows and you want to delete them, select the rows and click Delete. This will erase the selected row(s) but only if they’re not already deleted. The long way around this task would be to select the row(s), right-click the selection and choose Delete from the submenu that appears. If you chose a block of contiguous rows, Excel will delete them all.
If you find yourself looking to undo a large group of changes and don’t want to swap hands between your keyboard and mouse, then Ctrl + – is for you! You can also use it to select multiple rows or non-contiguous selections.
The best way to delete the current column in Excel is to press an X and then select the top-row in that empty row.
With a new series of analysis pieces, Windows aims to show users all the people and processes that contribute to the success of its products.
Microsoft has released new updates for Windows 11. Many people are eager to improve their security and productivity with these updates. With the release of Windows 11 22H2, it’s convenient to say that they’ve improved since Windows 11 22J2.
Windows 10 Security Checklist
Microsoft has a variety of security services that help protect your network from various external threats.
The easiest way to clear the DNS cache on Windows 10
It’s easy to delete individual rows or columns of data in Excel. Select the cells you want to delete, right-click and choose Delete. Be careful when working with contiguous columns: Excel will delete any that are adjacent to the selected cells.
Just like you can use Ctrl + Z to undo the last action, you can also use Ctrl+-to delete multiple rows. Select a row and then press Ctrl+-to delete that line, or if you have more than one column selected, just select both and press Ctrl+-to delete all of them simultaneously.
To insert a row (or column) in Excel, enter the Alt-Key combination CTRL and the specific number of rows or columns that you want to add, such as 3 Rows or 5 columns.
If you don’t have time to save content, or manage the information that’s already present in your browser, use the Insert key on your keyboard. Right-click any selected row(s) and choose Insert from the resulting submenu to save the changes you make.
Excel provides the keyboard shortcut Ctrl + Shift + + to insert a blank row without having to select multiple rows first. This also works with contiguous and non-contiguous selections, and includes the same number of blank rows as your selection.
Excel has tons of features, but this one is super simple.
To insert columns, select the column and then right-click it. Choose Insert from the submenu that appears. If you select Contiguous columns, Excel will insert the same number of blank columns to the left of them.
In Excel, Ctrl + Shift + + allows you to quickly select a range of cells. Hold the key down, start in the upper-left corner, and move your cursor until all of the cells you want to select are highlighted. Scroll through the selection with your mouse scroll wheel and drop down with your selection onto any blank cell below or on the right-hand side.
Excel’s AutoFit function enables you to be the row aligner and excel user with basic knowledge of Excel. Here’s a step-by-step guide that shows how to set your data up so it will automatically transform into cell content.
When you can’t read the content in a row, because the row height isn’t adequate, and you want to quickly change it, simply hover over the header cell and double-click. This will increase the row’s height property to accommodate the content. It also works with contiguous and non-contiguous selections.
Here’s how to apply AutoFit to a column in Excel:
Being able to format a cell in one row, row, or column can be helpful. To apply AutoFit to increase the width of a column, select the column and double-click either of the header cell’s borders. This shortcut also works with contiguous or non-contiguous column selections
To hide a row in Microsoft Excel
This shortcut lets you hide rows or selections of contiguous and non-contiguous rows in just seconds. Simply select what you want with the left mouse button and then press the shortcut: Ctrl + 9. That’s all there is to it!
This article will teach you how to hide a column within Excel.
The keyboard shortcut to hide (and therefore, un-select) a column, a contiguous selection of columns, or a non-contiguous selection is Ctrl + 0. It’s written as a zero followed by an uppercase O.
Why would you want to unhide rows and columns in Excel? What difference will this make in your workbook?
Because you have to select a cell in the rows adjacent to the hidden rows, unhiding a row requires a bit more work than simply hiding them. If you’ve hidden rows 4, 5, and 6, for instance, one of your tasks is to take care of selecting a cell in both row 3 and row 7. One pressing Shift + Ctrl + 9 will undo the previous manipulation and all your rows will be visible again.
To unhide columns, select a cell on the left and right of the hidden columns. Then press Shift + Ctrl + 0.
To unhide all columns and rows in the sheet, click the sheet selector at the intersection of the row and column header cells. Doing so will select the entire sheet, then press Shift + Ctrl + 9 and Shift + Ctrl + 0 to unhide everything.
