Copy and paste only nonblank cells
Unfortunately, when you try to paste a series of cells with blank cells,
option doesn't seem to work.
How to change default chart
When Excel is installed, the default chart is a 2-D Column chart but you can easily change the default chart type.
Using Shortcut keys to create a Chart
Excel propose easy and very fast way to create a chart by using shortcut keys.
Apply or remove cell borders
Exist several ways to apply or remove cell borders, you can choose anyone:
Saving Changes to Existing Workbooks
Saving your document in the same location with the same name is easy.
6 ways to open an Excel workbook
The Open dialog box, is your key to finding and retrieving Excel workbooks.
Adding Commands to the Quick Access Toolbar
Suppose you'd like to add a couple more commands to the
toolbar. Also, say you're a big fan of
. You can add the
button to the
toolbar, so you can quickly create and use
How to select all the embedded charts on the worksheet
If you need to select all objects embedded into the worksheet, e.g. select all charts to adjust their size, press
and click the
button or use
to select objects individually.
Inserting functions into formulas
The easiest way to enter a function into a formula is to use the Excel program's
Creating and using named ranges
Range names is a powerful Excel feature which allows you to give a symbolic name for the cell or range of cells to be later used as convenient replacement for cell/range address in formulas.
Copyright 2009-2017 by OfficeToolTips Team