excel+courses - splitting cells
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 » excel+courses - Splitting cells

excel+courses - Splitting cells

resolvedResolved · Low Priority · Version Standard

replyReply Fri 16 Nov 2007, 11:48Delegate Dara said...

Dara has attended:
Excel Intermediate course

Splitting cells

Morning,
How do I split a cell? In other words make a cell half it's orignal size.
Thanks,

For upcoming training course dates see: Pricing & availability

replyReply Sat 17 Nov 2007, 11:25Trainer Pete said...

RE: splitting cells

Hi Dara, Thank you for your post, I am not sure how this could be accomplished in Excel, if thats where you mean, you can merge cells and then return them to the original configuration, either using the Merge and Centre button on the toolbar or using the Format Cells, Alignment tab and choose merge to create one large cell from a selected range, however I dont know of a way to split a single cell. In Word and PowerPoint this can be accomplished in a Table by utilising the Tables and Border toolbar and using the Drawing tool (first button left hand side - looks like a pencil) to create customised cells, to rub out lines use the rubber tool, right next to the drawing tool) I hope that answers your question, regards Pete.

 

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

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