 |
| Excel shorts |
Excel Shorts
Lets continue our series with more interesting stuff which will help you.
Let's go.....
Paste Special
Grabbing (ie Copying) some data from one cell and pasting it into another cell is one among the foremost common activities in Excel. But there is a lot you would possibly copy (formatting, value, formula, comments, etc) and sometimes you will not want to repeat all of it. the foremost common example of this is often where you would like to lose the formatting - the place this data goes is your own spreadsheet together with your own styling. It's annoying and ugly to plonk in formatting from elsewhere. So just copy the values and every one you will get is that the text, number, regardless of the value is. The shortcut after copying the cell (Ctrl C) is Alt E S V - easier to try to to than it sounds.
The other big one is Transpose. This flips rows and columns around in seconds. Shortcut Alt E S E.
Print Optimisation
Everyone has problems printing from Excel. But imagine if what you printed were always just what you intended. it's possible. But there are a couple of components to this: print preview, fit one page, adjusting margins, print selection, printing headers, portrait vs landscape and spreadsheet design. Invest the time to get comfortable with it. you will be completing this task many, repeatedly in your working life.
Format Cells
Manual formatting (as against Conditional Formatting) is additionally important. you'll change the font face, font size, font colour, background and border of a cell to draw the user to certain areas of your spreadsheet. Use sparingly for greatest impact. inspect Styles within the Ribbon for quick and mostly non-garish formatting options.
That's it for today guys...
you have any query or want any help related to excel feel free to join our Telegram channel and message us..
Channel link :
0 Comments