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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
hidding and unhidding figures

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Hidding and unhidding figures

Hidding and unhidding figures

ResolvedVersion 2007

Femi has attended:
Excel Introduction course

Hidding and unhidding figures

how do i hide and unhide figures

RE: Hidding and unhidding figures

Hi Femi,

Thank you for your question.

If you select a column or row of figures, navigate to the Home Tab and the Cells group and choose Format. Select Hide/Unhide from the Visibility section and choose either hide rows or columns.

To unhide the hidden data, select the row before and row after or the column before and after and follow the same instructions above but finally choosing unhide rows or columns.

I hope this answers your question.

Regards

Simon

Excel tip:

Line breaks in a cell

You can control the line breaks for multiple-line headings or labels in your Microsoft Excel worksheet, just like you do in Microsoft Word. Here's how to do it.

Click the cell where you want the label or heading to appear.
Type the first line of information.
Press ALT+ENTER.

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.09 secs.