Catalog / Office & Productivity Tools Cheatsheet
Office & Productivity Tools Cheatsheet
A comprehensive guide to essential office and productivity tools, covering their core functionalities, shortcuts, and best practices to enhance efficiency and collaboration.
Microsoft Office Suite
Microsoft Word
|
Ctrl + B |
Bold selected text. |
|
Ctrl + I |
Italicize selected text. |
|
Ctrl + U |
Underline selected text. |
|
Ctrl + S |
Save the current document. |
|
Ctrl + P |
Print the current document. |
|
Ctrl + Z |
Undo the last action. |
|
Ctrl + Y |
Redo the last undone action. |
|
Ctrl + F |
Open the Find dialog. |
|
Ctrl + H |
Open the Replace dialog. |
Microsoft Excel
|
Ctrl + 1 |
Format Cells dialog. |
|
Ctrl + Shift + L |
Toggle Filter. |
|
Ctrl + Space |
Select entire column. |
|
Shift + Space |
Select entire row. |
|
Ctrl + ; |
Insert current date. |
|
Ctrl + Shift + : |
Insert current time. |
|
=SUM(A1:A10) |
Sum values in cells A1 to A10. |
|
=AVERAGE(A1:A10) |
Calculate average of values in cells A1 to A10. |
|
=IF(A1>0, “Yes”, “No”) |
Conditional statement. If A1 is greater than 0, return “Yes”, otherwise “No”. |
Microsoft PowerPoint
|
Ctrl + M |
Insert a new slide. |
|
F5 |
Start presentation from the beginning. |
|
Shift + F5 |
Start presentation from the current slide. |
|
Ctrl + D |
Duplicate selected object. |
|
Ctrl + G |
Group selected objects. |
|
Ctrl + Shift + G |
Ungroup selected objects. |
|
Ctrl + K |
Insert a hyperlink. |
|
Esc |
End slideshow. |
|
B or . |
Black screen during slideshow. |
Google Workspace
Google Docs
|
Ctrl + Alt + M |
Insert comment. |
|
Ctrl + Shift + C |
See word count. |
|
Ctrl + / |
Access menus with keyboard. |
|
@ |
Mention people or insert files/events. |
|
Ctrl + K |
Insert hyperlink. |
|
Ctrl + Shift + V |
Paste without formatting. |
|
Tools > Voice Typing |
Activate voice typing. |
|
File > Make a copy |
Duplicate the document. |
|
File > Download |
Download the document in various formats. |
Google Sheets
|
Ctrl + Enter |
Stay in cell after entering data. |
|
Alt + Enter |
Start a new line within a cell. |
|
Shift + Space |
Select the entire row. |
|
Ctrl + Space |
Select the entire column. |
|
Ctrl + Shift + Space |
Select the entire sheet. |
|
=SUM(A1:A10) |
Calculate the sum of cells A1 through A10. |
|
=AVERAGE(A1:A10) |
Calculate the average of cells A1 through A10. |
|
=COUNT(A1:A10) |
Count the number of cells with numerical values. |
|
=TODAY() |
Insert the current date. |
Google Slides
|
Ctrl + Shift + B |
Bold selected text. |
|
Ctrl + Shift + I |
Italicize selected text. |
|
Ctrl + Alt + C |
Copy formatting. |
|
Ctrl + Alt + V |
Paste formatting. |
|
Ctrl + Shift + Up/Down |
Move elements forward or backward. |
|
Ctrl + Alt + Shift + Up/Down |
Move elements to the front or back. |
|
Start presentation |
Click present in the top right corner. |
|
Insert > New slide |
Add a new slide. |
|
File > Download |
Download the presentation in various formats. |
Project Management Tools
Asana
|
Tab + Q |
Quick add task. |
|
Tab + P |
Open project actions menu. |
|
Tab + S |
Open search. |
|
Tab + X |
Open quick actions. |
|
N |
Create a new task in list view. |
|
Assignee |
Set who is responsible for the task. |
|
Due Date |
Set deadlines to keep project on track. |
|
Dependencies |
Link tasks to manage priorities. |
|
Sections |
Organize your tasks by list or board views. |
Trello
|
Q |
Open the cards filter menu. |
|
C |
Archive the current card. |
|
Spacebar |
Assign yourself to a card. |
|
L |
Open the labels menu. |
|
D |
Open the due date menu. |
|
N |
Add a new card to the current list. |
|
Drag and Drop |
Move cards between lists. |
|
Checklists |
Break down tasks into smaller steps. |
|
Power-Ups |
Enhance functionality. |
Jira
|
C |
Create a new issue. |
|
. |
Open the operation dialog. |
|
/ |
Quick search. |
|
W |
Assign to me. |
|
T |
Take transition. |
|
Esc |
Close dialogs/menus. |
|
Epics |
Break down large projects. |
|
Sprints |
Manage work cycles efficiently. |
|
Workflow |
Automate steps within a project. |
Communication & Collaboration Tools
Slack
|
Ctrl + K or Cmd + K |
Quick Switcher to navigate channels and DMs. |
|
Ctrl + Shift + M or Cmd + Shift + M |
Mark all messages as read. |
|
Up/Down Arrow |
Edit the last message. |
|
/ |
List available slash commands. |
|
@mention |
Mention a user. |
|
#channel |
Link to a channel. |
|
Starred Messages |
Save important messages. |
|
Threads |
Keep conversations organized. |
|
Integrations |
Connect to other apps. |
Microsoft Teams
|
Ctrl + E or Cmd + E |
Quickly access the search bar. |
|
Ctrl + Shift + M or Cmd + Shift + M |
Mute/Unmute during a call. |
|
Ctrl + O or Cmd + O |
Open file explorer. |
|
/ |
View available commands. |
|
@mention |
Mention someone in a chat. |
|
#channel |
Link to a channel. |
|
Tabs |
Integrate with other apps. |
|
Meetings |
Schedule and join meetings. |
|
Files |
Share and collaborate on files. |
Zoom
|
Alt + A |
Mute/Unmute audio. |
|
Alt + V |
Start/Stop video. |
|
Alt + M |
Mute/Unmute everyone (host only). |
|
Alt + S |
Share screen. |
|
Alt + R |
Start/Stop recording. |
|
Spacebar |
Push-to-talk (when muted). |
|
Breakout Rooms |
Facilitate small group discussions. |
|
Virtual Backgrounds |
Customize your background. |
|
Polling |
Engage audience. |