Now you can fill out the 2017 sales data. You have essentially “carved out” space in your spreadsheet. The number of rows inserted equals the number of rows of your original selection. Choose “Insert”.Įxcel will insert multiple rows above your selection. Then right-click anywhere in the row header for the rows you selected (i.e., right-click anywhere in the light green area). Doing this will add a kind of “spacer” row once we insert rows above this selection. Note: I am also selecting the blank row below the “2018 Total” row. In our example, select all the rows containing 2018 data. You can insert multiple rows at once by first selecting the number of rows you want to insert. While you could just enter the key combination mentioned above multiple times, there is a faster way. But let’s say your boss also wants to see the 2017 sales info. You just completed a schedule for 2018 sales. Now you can fill in the info for February and complete your schedule. You should now see a blank row above the “March” row and below the “January” row. Then, while still holding the ALT key, press the key for the letter “R”. While holding the ALT key, first press the key for the letter “I”. Now you’ll need to perform a keyboard combination to insert a row. In our example, select a cell anywhere on Row 7 (i.e., the “March” row). c) While having entire row selected, mouse click on the Insert icon. b) While having a single cell selected, press 'Ctrl - +' and choose Insert entire row. When you insert a row, Excel will insert the row above your current row. In Excel, you can insert a row in multiple ways: a) While having a single cell selected, mouse click on the tiny arrow under Insert -> Insert sheet rows. Let’s insert a row in between January and March. You’ve built a draft schedule but then realized you accidentally skipped February. Let’s say you’re building a schedule that shows sales by month for a few states. If you would like to work in my example Excel file, you can download it here from Google Drive. Let’s break that down with some screenshots. This key combination will insert a row above your current row. The keyboard shortcut to insert a row in Excel is to hold the ALT key, press the “I” key, and then press the “R” key. But this keyboard shortcut, like all keyboard shortcuts, is a faster way. ![]() Did you know there is a keyboard shortcut to insert a row in Excel? Most people know that you can right-click on a row and then choose “Insert” to insert a row.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |