Hi Friends Can any body tell me how to format an excel worksheet without row and column lines (making it absolutely white).Please post the detailed procedure. Bye Naga Praveen
From India, Hyderabad
smrin
15

Hi Praveen,
Please find the short cut way to merge work sheet (making it absolutely white) press CLRl A then click merge cell icon which is on the the excel sheet.
Do let me know if u want any not able to get me.
kindly send me your mail is to forward the same excel sheet..
Regards,
Regards,
Smrin...

From India, Hyderabad
hi,Praveen
follow the following steps to remove the rows and columns in an excel sheet......
select the worksheet you want to get clear of rows and columns
go to tools
then select options
then on the view tab under the windows option,select clear the gridlines
you will get the desired result
i hope this works
have a gd day

From India, Asansol
Asalamoalikum:
You can do it simply by clicking Tools in Menu bar & than Option & than uncheck grid lines option & OK. You will find all of the sheet blank/white (without lines). In addition, you can insert borders from format to cell option to draw lines whereever you want.
Regards
Sadaf Anjum

From Pakistan, Lahore
Hi Praveen, Just select the excel sheet and fill colour with white and you will get the desired result. Regards, Akhouri Nishant
From India, New Delhi
Hi Praveen
In an Excel sheet Go to Tools in Menu Click on it.Then you find Options, Click on it you will find an options window.In options window you Click on View tab.
In view tab window you find options like show, comment, objects and window options.In Window options you just just check off Gridlines and Press OK Button.Now your EXCEL Sheet becomes white as you asked.Try for it.
Regards
Suman

From India, Hyderabad
Open Excel. Go to Tools menu, Click View and untick gridlines. Now your entire worksheet will be white i.e. w/o gridlines.

Hi Praveen,
You will get two ways to white paper in Excel
1. If you are using version 2007 go to View menu then click the 'Show/hide' button just untick the 'grid lines' but cursor moves cell to cell.
2. Select the cells and merge the cells what ever work area you want. 'Merge' option in Home Menu. in this cursor moves like word document.

From India
Hi Praveen, I will change the border color to white! go to format cell/border. regards azi
From Malaysia, Kuala Lumpur
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.