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

excel training uk - excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training uk - Excel

excel training uk - Excel

ResolvedVersion Standard

Zana has attended:
Outlook Advanced course
Word Advanced course

Excel

Is there any short cut keys to hide and unhide in Excel?

Edited on Wed 7 Nov 2007, 11:23

RE: Excel

Hi Zana, Thanks for the post, I hope you have enjoyed the courses you have attended, in response to your post the keyboard combinations to Hide and Unhide are; Select the columns/rows then use ALT+O+C+H to hide and select either side of the hidden columns/rows and use keyboard combination: ALT+O+C+U to unhide. Hope that answers your question, Best regards Pete

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes


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.