What is the shortcut to insert a worksheet?
Microsoft Excel is extensively used across the globe to store and analyze data. Despite various new data analytics tools in the market, Excel remains the go-to product
for working with data. It has numerous in-built features, which makes it easier for you to organize your data. The shortcut keys in Excel help you work on your data in a jiffy. In this article, we’ll be discussing the various Excel shortcuts. These keyboard shortcuts are used to perform tasks faster and effectively. Although many of you are already aware of Excel, let’s have a small introduction anyways. Microsoft Excel is an application developed by Microsoft that is used to record, analyze, and visualize data. Excel, a spreadsheet application, was developed by Microsoft in 1985. Fig: Microsoft Excel Spreadsheet Data in Excel is in the form of rows and columns. Excel is
commonly used to record and analyze data, perform mathematical operations, and visualize structured data in charts and graphs. Finally, another important application of Excel is that it helps in automating tasks through excel macros. To perform the tasks mentioned above quickly, Excel has a set of shortcuts. Various operations can be achieved with a few simple keyboard strokes. Let’s dive deep into the Excel shortcuts that can help us work better on an Excel spreadsheet. Excel supports a plethora of keyboard shortcuts
that help you work efficiently and increase productivity. Instead of accessing the toolbar with a mouse, two or three keystrokes are used to perform significant functions. Isn’t that easier and time-saving? Using Excel shortcuts drastically increases the speed, and thus reduces work-time. Now the question is, if you have to memorize these shortcuts, the answer is no. However, it would be an advantage if you can remember a few of them. With regular practice, you will be able to
remember most of the common Excel shortcuts. Let’s now look at the Excel shortcuts cheat sheet, which you should know when working on Microsoft Excel. In this article, we have categorized 50 Excel shortcuts based on their operations. First, we will look at the workbook shortcut keys. In this section, we will understand the basics of operating a
workbook. We will learn how to create a new workbook, open an existing workbook, and save a spreadsheet so that you don’t lose any data or calculations that you have done. We will then go through how you can toggle between several different sheets in a workbook. Description Excel Shortcuts 1. To create a new workbook Ctrl + N 2. To open an existing workbook Ctrl + O 3. To save a workbook/spreadsheet Ctrl + S 4. To close the current workbook Ctrl + W 5. To close Excel Ctrl + F4 6. To move to the next sheet Ctrl + PageDown 7. To move to the previous sheet Ctrl + PageUp 8. To go to the Data tab Alt + A 9. To go to the View tab Alt + W 10. To go the Formula tab Alt + M Those were the Excel shortcuts that can help you navigate through your spreadsheet. Once the workbook creation is done, the next key step is cell formatting. A cell in Excel holds all the data that you are working on. Several different shortcuts can be
applied to a cell, such as editing a cell, aligning cell contents, adding a border to a cell, adding an outline to all the selected cells, and many more. Here is a sneak peek into these Excel shortcuts.
In addition to the above-mentioned cell formatting shortcuts, let’s look at a few more additional and advanced cell formatting Excel shortcuts, that might come handy. We will learn how to add a comment to a cell. Comments are helpful when giving extra information about cell content. We will also learn how to find value and replace it with another value in the spreadsheet. After this, we will look into how to insert the current time, current date, activate a filter, and add a hyperlink to a cell. Finally, we will see how to apply a format to the data in a cell.
After working with cell formatting Excel shortcuts, the next step is to understand how to work with an entire row/column in Excel. Row and Column Formatting Shortcut KeysIn this section, we’ll look at some critical row and column formatting shortcuts. We will understand how to delete rows and columns, hide and unhide the selected rows and columns, and group and ungroup rows and columns.
Now that we have looked at the different shortcut keys for formatting cells, rows, and columns, it is time to jump into understanding an advanced topic in Excel, i.e. dealing with pivot tables. Let’s look at the different shortcuts to summarize your data using a pivot table. Pivot Table Shortcut KeysFirst, let’s create a pivot table using a sales dataset. In the image below you can see that we have a pivot table to summarize the total sales for each subcategory of the product under each category. Fig: Pivot table using sales data
The image below depicts that we have grouped the sales of bookcases and chairs subcategories into Group 1.
You can see below we have hidden the Chairs, Art, and Label subcategories.
Fig: Pivot chart on the same sheet Have a look at the video below that explains worksheet related shortcuts, row and column shortcuts, and pivot table shortcut keys.ConclusionExcel shortcut keys will indeed help you build your reports and analysis faster and better. After reading this article, you would have understood the different types of Excel shortcuts related to the workbook, cell formatting, row and column formatting, and pivot tables. To kick-start your fruitful career in Excel, enroll in Business Analytics with Excel course. We hope you find these hacks useful and can easily master these shortcut keys by working on excel regularly. Do you have any questions related to this article? If so, then please put it in the comments section of the article and our experts will get back to you at the earliest. What is keyboard shortcut to insert a worksheet?Hold down SHIFT, and then select the same number of existing sheet tabs of the worksheets that you want to insert in the open workbook. For example, if you want to add three new worksheets, select three sheet tabs of existing worksheets. On the Home tab, in the Cells group, click Insert, and then click Insert Sheet.
How do you insert a worksheet in Excel?Using the Insert option on the Home tab in the Excel Ribbon bar we can insert new sheet in the workbook. Simply go to the Home tab, in the Cells group, click on the Insert option and select New Sheet.
What is the shortcut for insert in Excel?Want to insert a table, row, column, comment, or chart? Press Ctrl + l to insert a table, Ctrl + Shift + + to insert a cell, row, or column, Ctrl + F2 to insert a comment, and Alt + F1 to insert a chart with data.
|