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

excel

ResolvedVersion 2003

Excel

What does a formula start with

RE: excel

Hi Marcy

Thank you for your question. To trigger the formula in a cell enter the equals symbol =
If you need to type the = symbol as the first character of a text label precede it with the single apostrophe. This tells Excel that everything that follows should be treated as text and not evaluated as a formula.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

RE: excel

Cheers for tht Andrew

Thu 12 Feb 2009: Automatically marked as resolved.

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

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