You can paste it as text only or with special formatting, and more. It will bring up the Paste Special Box where you can choose how you’d like to paste your data in. If you need to paste data from an external source, use CTRL + ALT + V.
Simply click on the column name or row number to select the entire row or column and use the shortcut as many times as you need to add more rows and columns. Using the CTRL + + shortcut, you can easily add as many rows or columns you need. To achieve the same on a Mac, use the CMD+ALT+0 shortcut.
In a similar fashion, you can quickly add borders around selected cells by using ALT+H shortcut on PC. Simply select the information you want to format, use the CTRL + 1 shortcut, and Excel will bring up a dialog box with all the formatting options for that object. This shortcut is a lifesaver when it comes to formatting cells, rows, objects, and pretty much anything else in Excel. Be sure to reorder the sheets to the correct order when you’re done adding them. While you can certainly click the + sign at the bottom of the sheet, this shortcut is a much faster way of achieving the same thing and you can repeat it as many times as you want. Use the Shift + F11 to quickly insert new sheet into your current workbook. You can also simply select the cell holding the data you need to repeat and drag the handle down across the needed number of cells. It’s useful when you need to repeat the same information in row cells - but not the entire row. Similarly to the shortcut above, you can quickly fill in the cell with the data from the cell that’s to the left of it by pressing CTRL + R. Fill in cell with data from adjacent cell Alternatively, click in the cell that holds the information you need to repeat and then drag the handle down by x amount of cells. Have you ever needed to repeat the same information in a few cells but not in the entire column? By pressing CTRL and D keys together, you can quickly fill in the cell with the information from the cell above. Press the CTRL + UP or Down arrow to get to the top or bottom of any column in your spreadsheet.ģ. It’s useful when you’re working with large amounts of data and need to scroll up to find a particular cell.Ģ. The Shift + Enter shortcut allows you to move up through a selection of cells in any sheet.
Search the spreadsheet or replace data.Fill in cell with data from adjacent cell.Jump to top or bottom of the spreadsheet.Now that we’ve covered why they are useful, here’s a list of the top 25 Excel shortcuts that every business owner should know to speed up their workflow and improve their spreadsheet creation and maintenance.
#Shortcut for switchign sheets on excel mac how to#
How to use Microsoft Excel more efficiently: 25 Excel shortcuts
Mastering Excel shortcuts also allows you to reduce the chance of human error because you can easily manipulate data and format it without having to stop what you’re doing and apply a certain formatting rule.Īnother reason why you should use Excel shortcuts is because you will get a better understanding of Excel, which in turn will allow you to create more complex spreadsheets and reports. Related: 13 ways to use Excel Why you should use Excel shortcutsĪs mentioned earlier, Excel shortcuts can help you save time when you need to input large amounts of data into your Excel workbook. In this post, we’ve rounded up various Excel shortcuts so you can spend more time focusing on work that matters instead of creating reports. Luckily, there are several handy Excel shortcuts that will help you save time and show you how to use Microsoft Excel more efficiently. Once you start using Excel to organize all that information and create various business reports, you’ll realize how time-consuming these tasks can be. You can use it for social media marketing as well as to keep track of your business operations and various data. Microsoft Excel is a powerful tool that can be used for more than just accounting.
0 kommentar(er)
