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

microsoft excel training day courses near kent - excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training day courses near kent - Excel

microsoft excel training day courses near kent - Excel

ResolvedVersion Standard

shaista has attended:
Excel Intermediate course

Excel

how can i print all workbooks?
p.s my email address is not corrct,it should be
shaista.gill@robertwalters.com

RE: excel

Hi Shaista, thank you for your post, I am assuming that you mean all Worksheets within a Workbook, to print each one on a new page you can use the group sheets function, to do this select the sheet names from the foot of the workbook, either use Click Shift Click to select touching sheets or use the CTRL key and Click to select sheets which are not touching, then when the sheets are grouped go to File, Print and follow the options in the dialog box, your sheets will now print one to a page (or more if they are bigger than one page), hope that helps, regards Pete.

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

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.