In this article, I’ll cover 10 Excel tips you can use to increase productivity and make your work easier. Be sure to read through the entire list so you can find the tips that are most helpful to you.
I’ll jump right into the action below. Be sure to bookmark this page so you can come back here in case you forget any of the helpful tips I’ll be sharing.
Use the status bar
Whenever you highlight a series of numbers, the status bar at the bottom of Excel gives you useful information. You can find information about the sum, the average and the total number of numbers.
Many people know the status bar, but did you know that you can right-click on it to add more features? For example, you can add the minimum and maximum values in a range.
Using shortcuts for quick navigation
If you need to quickly navigate through a sheet, you can use the following keyboard shortcuts.
- Ctrl+End – navigate to the rightmost cell where you entered data.
- Ctrl+home – navigate to the beginning.
- Ctrl+Right Arrow – Navigate to the rightmost corner of the Excel sheet.
- Ctrl+Left Arrow – Navigate to the leftmost corner of the Excel sheet.
- Ctrl+Up Arrow – Navigate to the top of the Excel sheet.
- Ctrl+Down Arrow – Navigate to the bottom of the Excel sheet.
If you want some rows to stay at the top of the Excel sheet as you scroll through them, select the row at click on the letter on the left, then click Vision on the top. Then click Freeze pans get the following options:
- Freeze Panes – Paste all, based on the current view.
- Freeze top row – Paste only the top row.
- Freeze First Column – Paste only the first column.
Speed Dial Formulas
This tip can save a lot of time if you are constantly entering formulas. When you start typing a formula, you can use the up/down arrow keys to move through the suggested formulas and the tab key to select that formula automatically. This method is often much faster than typing out a formula every time.
If you are filling a range of data, you can highlight that range and then drag it down to automatically fill more cells with the following information. There are many ways you can use this to be more productive. For example, it can be used to automatically enter consecutive dates.
Excel is smart at guessing what information to autofill. For example, if you have a column that appears every third day, it can follow that pattern with the autofill feature.
Create a macro to automate a task
If there are tasks that you perform repeatedly in Excel, you can create a macro to automate the process. To do this, follow the steps below.
- Click File.
- Click Options.
- Click Customize ribbon.
- Below the head tab, select to open the . to activate Developer box†
- Click OKAY.
- utilities, click on the new one Developer tab at the top of the Excel ribbon.
- Then click on the Record Macro knob.
- utilities, name the macro and choose a shortcut for it.
- You can also add a description to make it easier for you in the future.
- Then perform each task as you normally would in Excel.
- When you’re done, Click Stop recording.
- You can now use the shortcut you created to directly run the task you recorded.
Create a beautiful table in seconds
You can create visually appealing tables in seconds by following the steps below.
- First, mark the desired data in the table.
- Go to the Insert tab†
- Click Table.
- The highlighted area now has a border around it.
- Click Okay to create the table.
You can use the table icons at the top right to change the colors and use the checkboxes below the design tab to change the layout.
You can also click the small icon below the table once your cursor is hovering over the table. This opens a small menu for creating charts, tables, formatting rules, and more.
Use Go to to find specific cells
If your Excel sheet has an overwhelming amount of data, it will be difficult to track everything down. You can use thise Go to tool to find specific cells more easily. It works the same way as the Search tool in Microsoft Word.
- First, select the data range where you want to find information.
- You can also just press Ctrl+A to select all.
- Look for the edit section on the Home tab in the top right corner.
- Click Go to†
- You can then enter a value, word or use the ‘special’ tab to find more specific elements.
Quick Tip: You can comment on cells you want to find easily later and then use the Remark selection in the Special tab when using Go To.
Change how ‘Enter’ works
By default, pressing Enter moves you down one cell, but there is a method to change how Enter works in Excel. To change this, go to Filethen Optionsand then click the Advanced tab†
From here, you can choose whether to move up, down, right, or left using the Enter key. Alternatively, you can just disable the functionality completely. This is useful if you want to hold enter as an easy way to confirm data and if you prefer to manually navigate through cells.
Copy same data in multiple cells at once
You can quickly copy the data from one cell to as many cells as you want. To do this, first press Ctrl+C on the cell you want to copy. Next one, highlight the cells you want to copy toand then press Ctrl+V†
Have these Excel tips proved helpful? I hope so. If you have any questions about the tips I’ve included in this article, please reach out to me on Twitter and I’ll get back to you as soon as possible. Enjoying!