excel+courses - splitting cells

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

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,

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.

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips


Server loaded in 0.1 secs.