98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsPrevious article Next article Excel articles
Customize Your Gridlines And Borders In Excel 2007
Thu 22nd October 2009
For this reason there are various methods that you can use to distinguish the gridlines in your Excel spreadsheet even more. The most obvious way of highlighting gridlines is to alter their colour. This command can be found in the Advanced Excel Options menu under Display Options. If your spreadsheet is themed in some way a relevant colour for your gridlines may be a nice touch. Alternatively, you may just want to make the information stand out more; if so a bold colour such as red will be useful.
As valuable as gridlines are on the screen they are not present when the spreadsheet is printed. This is to provide a cleaner, less cluttered look to the document as opposed to the rigidity and formalised structure that gridlines suggest. However, there are times when printed gridlines can be necessary and even desirable. In cases like these it is a simple matter to alter the print settings to ensure that your document prints with gridlines intact. Select page layout on the ribbon and then from there click page setup. Ticking the gridlines box will give you a printed spreadsheet replete with gridlines.
The reverse of this exercise is also true, since as you can remove the gridlines on the screen version of your workbook. Whilst this may be wise for certain types of spreadsheet you should be careful that doing so will not result in confusion between cells and the data within them. To hide gridlines on your spreadsheet go to the show/hide group in the view tab and clear the gridlines box.
Whilst these various tricks can be performed on gridlines it is not possible to customize them to the extent that cells and borders can be customized. For example you can create a custom border by going into the cell styles option and selecting new cell styles. This will allow you to create a name for the specific style as well as select the line and colour that you want to use. Then under the border option you can select the border that suits the project best. To apply this customized style to cells on your spreadsheet simply select the appropriate cells and then click on your new cell style in the styles group.
These methods for changing gridlines and cell borders may appear straightforward but a good many people do not realise that it is possible to do such things. Many of Excel's default settings can be customized to a greater or lesser extent if you know where to look and what steps to follow. Proper training in Microsoft Excel will open up a whole world of handy tips and tricks to get your workbooks looking their best.
Author is a freelance copywriter. For more information on excel microsoft training, please visit https://www.stl-training.co.uk
Original article appears here:
https://www.stl-training.co.uk/article-634-customize-your-gridlines-and-borders-in-excel-2007.html
London's widest choice in
dates, venues, and prices
Public Schedule:
On-site / Closed company:
TestimonialsMurray Birrell
Building Surveyor Steven Mcdonnell Finance for Non-Financial Managers Very good trainer presented very calmly and a good pace and took his time to take questions and personalise the experience. Reed Business Information
Digital Producer Averil Dourado Photoshop Introduction Alan's teaching was very thorough and even those of us with some previous experience of Photoshop benefitted from his knowledge. I've learnt so much about how and why things work in Photoshop and will definitely be able to use his shortcuts to improve my day-to-day workflow. Thank you! Moët Hennessy UK Ltd
Business Controlling Intern Hayrican Aydogan Excel Advanced The training was amazing. It was extremely helpful to optimize the daily tasks in Excel. It could just be extended to two or three days as it was a bit intensive. |
PUBLICATION GUIDELINES