Sat 11 Feb 2017

Tips & Tricks 155 - Gridlines not Visible, Help!!

By |Saturday, February 11th, 2017|Categories: Tips and Tricks|Tags: , , , , , , |0 Comments

You may try following one by one and verify your results

1. Update your Printer Driver to latest from internet (Or change your default printer driver to PDF/XPS/One Note)

2. Select the triangle between row 1 and column A to select entire sheet (or CTRL+A, 3 times).

Home tab > Go to Paint Bucket and select No Fill (or any other color other than white).

1

3. View tab > Check Gridlines if not already checked.

2

4. File > Options > Advanced

Make sure Gridline color is set Automatic (or any other color other than white)

3

5. Select the triangle between row 1 and column A to select entire sheet (or CTRL+A, 3 times) > Right Click > Format Cells > Border Color should be Automatic or any other color other than white.

4

Sat 01 Oct 2016

Tips & Tricks 146 - When I input a number, Excel automatically inserts a decimal with 2 decimal points

By |Saturday, October 01st, 2016|Categories: Tips and Tricks|Tags: , , , , |0 Comments

Sometimes, you might face a problem that you input a number say 567 and it automatically becomes 5.67. If you enter 8, it becomes 0.08.

To correct this problem > File > Options > Advanced and uncheck Red Zone

1

Sat 23 Jan 2016

Tips & Tricks 127 - Change Default File Extension for Saving

By |Saturday, January 23rd, 2016|Categories: Tips and Tricks|Tags: , , , , , , , , |0 Comments

We know that when we save an Excel file, it gets saved as .xlsx file.

1

But sometimes, few users may need to change the default file extension to something else. You can change it in

File > Options > Save

1

Sat 08 Nov 2014

Tips & Tricks 64 - Show a 0 in place of Blanks in Pivot Table

By |Saturday, November 08th, 2014|Categories: Tips and Tricks|Tags: , , , , |0 Comments

When you create a pivot table and if a source cell has no value (i.e. cell is blank), in pivot table, it will show a blank. All other results in pivot table are carrying numeric values and you see blanks. It is odd though it doesn't impact the results.

1

But you still prefer to show this as 0.

1. Click anywhere in the pivot table and choose PivotTable Options.

2. Make "For empty cells show" box 0.

1