There are multiple ways to rename sheets, and most users will right click to choose Rename, which actually wastes a lot of time. The best way is to just click twice, then you can rename it directly.
All About new tips and tricks about Software from various sources
Sunday, 10 April 2016
Saturday, 9 April 2016
EXCEL : One Click to Get More Status
Most users know how to check the data status in the bottom of an Excel sheet, like Average and Sum Value. However, do you know you can move the pointer to the bottom tab and right click to get more status, as shown below?
Friday, 8 April 2016
EXCEL : Speed up Inputting Complicated Terms with AutoCorrect
If you need to repeat the same value and it is complicated to input, the best way is to use the AutoCorrect function, which will replace your text with the correct text. Take my name, Liza Brown, for example, which can be replaced by LZ. Therefore, every time I input LZ, it can autocorrect to Liza Brown. Go to File->Options->Proofing->AutoCorrect Options and input Replace text with correct text in the red rectangular area, as below.
Thursday, 7 April 2016
EXCEL : Add More Than One New Row or Column
You may know the way to add one new row or column, but it really wastes a lot of time if you need to insert more than one of these by repeating this action X number of times. The best way is to drag and select X rows or columns (X is two or more) if you want to add X rows or columns above or left. Right click the highlighted rows or columns and choose Insert from the drop down menu. New rows will be inserted above the row or to the left of the column you first selected.
For more click here
EXCEL : Transpose Data from a Row to a Column
You would use this feature if you want to transpose data to get a better display; however, retyping all data would be the last thing you would need to do if you know how to use the Transpose function in Paste. Here’s how: copy the area you want to transpose, move the pointer to another blank location. Go to Home->Paste->Transpose, please note that this function won’t activate until you copy the data first.
For more click here
Read More »
For more click here
Wednesday, 6 April 2016
EXCEL:Create a New Shortcut Menu
Generally there are three shortcuts in the top menu, which are Save, Undo Typing and Repeat Typing. However, if you want to use more shortcuts, like Copy and Cut, you can set them up as follows:
File->Options->Quick Access Toolbar, add Cut and Copy from the left column to the right, save it. You will see two more shortcuts added in the top menu.
Tuesday, 5 April 2016
EXCEL : Compose Text with &
Complicated formulation is unnecessary, as long as you know how to use &. You can compose any text freely with this symbol. Below I have four columns with different texts, but what if I want to compose them to one value in one cell? First, locate the cell that is to show the composed result, use the formulation with & as shown in the screenshot below. Click Enter: all texts in A2, B2, C2 and D2 will be composed together to become LizaUSA25@ in F2.
For more click here
EXCEL : One Click to Select All
You might know how to select all by using the Ctrl + A shortcut, but few know that with only one click of the corner button, as shown in the screenshot below, all data will be selected in seconds.
For more click here
Subscribe to:
Posts (Atom)