vba excel - excel
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » vba excel - Excel

vba excel - Excel

resolvedResolved · Low Priority · Version Standard

replyReply Mon 24 Sep 2007, 13:50Delegate Toby said...

Toby has attended:
Excel Introduction course

Excel

How do i do borders?

For upcoming training course dates see: Pricing & availability

replyReply Tue 25 Sep 2007, 12:12Trainer Anthony said...

RE: Excel

Hi Toby. Simple select the cell whose border you want to reformat and the select Format - Cells and then the Borders tab to reformat.

Hope this helps,

Anthony

 

Excel tip:

Freeze Rows and Columns to keep lables displayed

You can freeze rows and columns in your worksheet so they don't move.

This allows you to keep row and column labels displayed on your screen as you move through a large worksheet.

Click below and/or to the right of the cell(s) you want to freeze. (NB. Excel freezes ALL the rows above and ALL the columns to left of the selected cell)

Click on the 'Windows' menu and selct 'Freeze Panes'.

Lines appear in your worksheet. The required rows and columns are frozen and remain on your screen as you move through your worksheet.

To unfreeze rows and columns, click on 'Window' menu and select 'Unfreeze Panes'.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard