cheat sheet excel

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cheat sheet for Excel

Cheat sheet for Excel

resolvedResolved · Low Priority · Version 2016

Sarah has attended:
Influencing Skills course

Cheat sheet for Excel

Hello,
The pdf version of the cheat sheet provided has some issues with the print at the bottom so is obscuring the text. Can a new version be made available?
Sarah

RE: Cheat sheet for Excel

Hi Sarah,

Here's a link to the cheat sheet. This version looks to be OK. If it's not can you confirm what you're using to view the file? Is it a browser or Adobe Acrobat or instance?

https://stlmicrosofttraining.sharepoint.com/ :b:/s/TrainingTeam/EWGNksTPfmhMgWGXN_HGXloBmuVFuy9Wet7Be2OI9qPVtQ?e=yO6bSJ

Please let me know how you get on.

Claire

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

RE: Cheat sheet for Excel

Hi Claire,
Thank you for getting back to me.
The topic I have is different. The filname is Excel Cheat Sheet v4.
Thanks
Sarah


 

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips


Server loaded in 0.06 secs.