Microsoft Excel is an incredibly useful software package, but it can be even more useful with these lesser-known shortcuts and tricks! Here are six must-know shortcuts you’ll want to use to save time and make your job easier. These shortcuts apply to Excel 2007 or later and Windows 7 or later. They may work in other versions of Microsoft Excel, but check the Excel Help menu first to see if there are instructions specific to your version of the software. 6 Tricks You Didn’t Know You Could Do in Microsoft Excel
Table of Contents
A Trick to quickly remove non-printable characters from a cell
A non-printable character is a special character that has no equivalent on your keyboard, but you need to use them in Excel. For example, you may want to type a minus sign (–) into a cell so that your spreadsheet will show negative values as such. Or maybe you want to put an ampersand (&) or an asterisk (*) into your cell; both of these characters have special functions in formulas. So how do you get around using these characters?
The Quickest Way to Enter A Formula.
Typing a formula is a huge time-waster. Instead, use your keyboard to quickly enter (and edit) formulas and change cell references. Here’s how: first click inside a cell that has a formula. Then press F2 on your keyboard to enter edit mode for that cell. Use your arrow keys to move around, then press F9 to automatically fill any remaining cells with whatever you’ve input so far.
How To Copy Another Workbook’s Sheets Into Your Workbook
Take an existing workbook and lift it into your new one, complete with all of its sheets. To do so, right-click on a sheet tab and select Move or Copy… Under Sheet options, select Move or copy to … and choose your workbook as the destination. If you have access to another workbook that contains sheets you would like to move into your new file, click OK.
A Trick To Change the Cell Value Without Changing The Formatting
If you need to change a cell’s content without modifying its formatting, here’s an easy shortcut. First, select and copy all of your data. Then, head to Google Sheets—the online alternative to Excel—and open a new blank document. Paste your copied cells into it by pressing Ctrl+V.
How To Quickly Enter a Summary Of Data From Multiple Columns and Rows In One Cell
This is one of my favorite Excel shortcuts. If you’re pulling a lot of data from multiple columns and rows and need to summarize it quickly, use Ctrl+Shift+Enter to enter data right into a formula. Let’s say you want to find out how many orders are still pending – simply select all your data and then enter =SUM(Pending) without first highlighting anything with your mouse.
Fast Way To Find Out All Unused Cells In A Worksheet
To find all unused cells that contain values: Subtract all used cells from total rows or columns to get them. Rows or columns with zero values can be deleted immediately without any need for further evaluation. Check each cell to see if it contains a value.