Become a spreadsheet wizard with these MS Excel tricks and hacks
More often than not when dealing with spreadsheets, Microsoft Excel is at the forefront of your business mind. Despite the ease and already well-known short-cuts using Excel we provide some familiar and not-so familiar tips and tricks below:
- Select all in one click
Most people know the Control + A shortcut, but did you know if you click into the top left corner of the worksheet you will select all?
- Add multiple new columns or rows
Adding one row or column is easy but if you want to add multiple rows or columns it can seem tiresome. Try this: drag and select the number of rows or columns you want to add, move to the cell you want to add above or below, right click the highlighted rows/columns and choose ‘Insert’ from the drop down menu. You will see new rows or columns where you selected them to be.
- Move Cell Data Fast
If you want to move a data cell quickly, the best way is to highlight the cell you want to move and then move your mouse pointer to the border. It should become a crossed arrow icon and you can then move the cell freely.
- Copying Cell Data Fast
Oh you wanted to copy it as well? Easy! Ensure you have held down the Control key before you drag the cell, the new column will copy the data.
- Hide data
You may be aware of the easy Hide function – right clicking then choosing Hide but this may not be a good option if your spreadsheet contains a small amount of data. The easiest way for this is to use the Format Cells function. Choose the area and then go Home>Font>Open Format Cells (the little icon on the bottom, right hand side of the box)>Number tab>Custom>Type>Click OK. All should be invisible unless you are in the preview area next to the Function button.
- Using Upper or Lower text formulation function
You can use different text in formulas for text to appear in upper, lower or proper case. Using upper after the = will enforce text to appear in UPPER CASE, lower in lowercase and proper for Proper Case.
- Inserting Zero into cells
Excel automatically deletes the first zero by default. You can fix it via Format Cells but a quick fix is to insert a single quote mark (‘) ahead of the zero and it will appear.
- Allowing for Terms to be input via AutoCorrect
If you are inputting a difficult or lengthy term such as a name you can enter the data into AutoCorrect function to add the lengthy term. For example if you want to add ‘A Lengthy Company Name’, it is possible to set up whenever you add AL it autocorrects the entry to A Lengthy Company Name. Go to File>Options>Proofing>Autocorrect Options and input. Enter the data you will input and the Replace data it will autocorrect.
- Renaming a sheet with one double click
Most users choose the Rename function but do you know you can just double click and rename? Try it.
- Quickly delete cell contents
Select your cells, click on the cross icon on the lower left corner of the selection and move it to the top and release the mouse.
So by now you will be inspired to test these tips and be on your way to becoming an Excel wizard.