Friday 28 March 2014

Remove Gridlines From excel sheet

Fed up with watching gridlines in you excel sheet ?

Steps

1. Open your worksheet , Go to Tools Menu > Options 
2. In View Tab , You can see Window Options 
3. By Defult Gridlines are ticked, Untick it , Click ok Button

Then You have it


Note: If you want to change color of gridlines, there is an option under it, change gridlines color in it & Tick Gridlines.

Give Superb look for your excel sheet

1. Remove Annoying Gridlines from your sheet Click here

2.Remove Page Breaks

Steps
1. Open your worksheet , Go to Tools Menu > Options 
2. In View Tab , You can see Window Options 
3. By Defult Page Breaks are ticked, Untick it , Click ok Button

3. Remove Row & Coloumn Headers 

 Steps
1. Open your worksheet , Go to Tools Menu > Options 
2. In View Tab , You can see Window Options 
3. By Defult Row & Coloumn Headers  are ticked, Untick it , Click ok Button

4. Remove Scroll bars

Steps
1. Open your worksheet , Go to Tools Menu > Options 
2. In View Tab , You can see Window Options 
3. By Defult Horizondal Scroll bars & Vertical Scroll bars  are ticked, Untick both  , Click ok Button

5. Remove sheet Tabs
Note: Only Use this option if you have only 1 worksheet / you have hyperlinks to other sheets.
Steps
1. Open your worksheet , Go to Tools Menu > Options 
2. In View Tab , You can see Window Options 
3. By Defult sheet Tabs  are ticked, Untick it  , Click ok Button

Excel Worksheet Shortcuts - Very useful


ActionKey
Moving Forward to next worksheetCtrl + pagedown
Moving Backward to next worksheetCtrl+ Pageup
Selecting Multiple worksheets- ForwardCtrl + Shift + pagedown
Selecting Multiple worksheets- BackwardCtrl + Shift + pageup


Excel Shortcuts: Selecting

These shortcuts help you to quickly select items in your Excel file in various ways.
  • Shift+Spacebar: Select the current Row
  • Ctrl+Spacebar: Select the current column
  • Ctrl+A: Select All, will select everything on the current worksheet. This is most often used in conjunction with the copy shortcut.