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

excel+courses - splitting cells

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+courses - Splitting cells

excel+courses - Splitting cells

ResolvedVersion 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:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.