• 512-991-7197
  • This email address is being protected from spambots. You need JavaScript enabled to view it.
  • Always Open

Welcome to Microsoft Excel Tips & Tricks

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
Unfortunately, when you try to paste a series of cells with blank cells, Paste special with Skip blanks option doesn't seem to work.

One of the solutions is to use Filter:

   1.   Select of the cells including blank and non-blank cell that you wish to paste.

   2.   On the Home tab, in the Editing group, select Sort & Filter and then choose Filter (or click Ctrl+Shift+L):

1

   3.   A drop-down should appear in the first cell of your range.

2

Click on this drop-down.

   4.   De-select the (Blanks) option and then click on the OK button:

3

   5.   You can see now only non-blank cells, select them:

4

   6.   Now you can copy and paste anywhere the series of cells without blank cells:

5

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
When Excel is installed, the default chart is a 2-D Column chart but you can easily change the default chart type.

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
For some workbooks with big number of sheets or to highlighting some important data, it is necessary to create hyperlinks to another cell in the same spreadsheet.
3

To do that, follow the next steps:

   1.   Right click on the cell where you would like to insert hyperlink and then select Hyperlink... from the popup menu:

1

   2.   On the Insert Hyperlink dialog box:

  1. Click on the Place in this Document button on the left.
  2. In the field Text to display enter the text that will be displayed in hyperlink.
  3. Enter the cell reference that the hyperlink points to (by default use the cell A1).
  4. Choose the sheet reference that the hyperlink points to.
  5. Click the OK button.
2

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
When you select a range of data, Excel displays a Quick Analysis button in the lower-right corner of the range. But this option can be turned off.
1

To turn on/off the Quick Analysis feature, follow next steps:

   1.   On the File tab, click the Options button:

2016

   2.   In the Excel Options dialog box, on the General tab check or uncheck Show Quick Analysis options on selection:

2

Note: You can also press Ctrl+Q on the keyboard to display the Quick Analysis options.


Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
Sometimes you need to omit some points of the chart axis, e.g., the zero point. This tip will show you how to hide certain points on the chart axis using custom label format.

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
This tip will help you to select all cells in the worksheet in one click.

A quick way to do so is to click the triangle at the intersection of the row headers and column headers:

Select all cells in Excel 2016

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values. As we have shown Creating a Waterfall chart it can be created using a combination of Excel Bar charts. This tip will show you how streamline this process using Error Bar chart. The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values.

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
Here's a quick way to unmerge all merged cells in a worksheet:

   1.   Select all cells in the worksheet.

A quick way to do so is to click the triangle at the intersection of the row headers and column headers:

1

   2.   On the Home tab, in the Alignment group:

  • If Merge & Center isn't highlighted, there are no merged cells in the selected area.
  • If the Merge & Center button is highlighted, click it:
2

   3.   In the Merge & Center list, select Unmerge Cells to unmerge all cells in the selected area:

3

Star InactiveStar InactiveStar InactiveStar InactiveStar Inactive
The waterfall chart is normally used for understanding how an initial value is affected by a series of intermediate positive or negative values. Usually the initial and the final values are represented by whole columns, while the intermediate values are denoted by floating columns.

Recommend other relevant articles:

 

 

© 2019 Austin Laptop [AustinLaptop.Com]. All Rights Reserved.