TallyPrime Notes Pdf

Click to download

Sample Table

Click to download

GST, TDS & Income Tax

Click to download

Keyboard shortcuts, hotkeys, and special keys (Windows)

Universal Shortcuts

Many keyboard shortcuts are universally functional across Windows programs. Take the classic Ctrl + C and Ctrl + V for copying and pasting—they perform seamlessly whether you’re managing files in File Explorer, editing text in Word, organizing data in Excel, designing in Photoshop or AutoCAD, or browsing the web. These combinations function seamlessly because they’re standardized, cutting repetitive tasks down to a swift two-key action. By integrating these universal commands, Windows boosts efficiency, allowing users to execute common actions instantly in nearly any software.”

This version emphasizes standardization, cross-application utility, and efficiency while maintaining clarity and varying sentence structure.

 

Shortcut KeysDescription
Ctrl + ASelect All
Ctrl + XCut the selection and store it in the clipboard
Ctrl + CCopy the selection and store it in the clipboard
Ctrl + VPaste the contents of the clipboard at the cursor
F5Refresh a webpage or folder’s contents
Ctrl + SSave a document, webpage or file
Ctrl + FFind
Ctrl + PPrint
Ctrl + ZUndo the last operation
Ctrl + YRedo the last operation
Ctrl + +/-Zoom in and out
Ctrl + 0Zoom to 100%
Ctrl + NNew document or internet session
Ctrl + OOpen a file or document

 

Formatting Shortcuts

These shortcuts can help you quickly format text no matter what application you’re writing in.

Shortcut KeysDescription
Ctrl + BBold
Ctrl + UUnderline
Ctrl + IItalics
Ctrl + Shift + AChange text to uppercase/lowercase
Win + .Access emoji keyboard

 

Internet Browsing Shortcuts

Mouse browsing is fast, but keyboard shortcuts can be faster. A quick keystroke often beats multiple clicks, making web navigation smoother.

Shortcut KeysDescription
Ctrl + TOpen new tab
Ctrl + WClose active tab
Ctrl + Shift + TReopen a recently closed tab
Ctrl + TabGo to the next tab
Ctrl + Shift + NOpen a new private browsing window
Ctrl + DSave the page as a Bookmark

 

Desktop Experience Shortcuts

These shortcut combinations can help you control your computer, and your desktop environment, with ease.

Shortcut KeysDescription
WinLaunch Start Menu
Win + DShow your desktop
Win + LLock your computer
Win + Right ArrowResize the window to half of the display and snap it right
Win + Left ArrowResize the window to half of the display and snap it left
Win + MMinimise all windows
Alt + TabShow all open applications
Alt + F4Close the focused window
F11Switch fullscreen/normal size
Win + TSwitch between apps in the taskbar
F2Rename object
Win + POpens the external display options menu
Ctrl + Win + CAccessibility/Ease of access settings
Ctrl + Alt + DelOpens the quick menu giving access to lock, switch user, sign out, change your password or open the task manager
Win + HDictate instead of typing text
Win + VAccess clipboard library (you’ll need to press this once to enable this function before it will work permanently)
Win + Shift + SAccess Snipping tool

 

Capturing Screenshots Shortcuts

If you need to capture a picture or a video of either your whole screen or just a portion of it these commands will help you achieve that. 

Shortcut KeysDescription
Prt ScOpens the Snipping Tool menu
Win + PrtscnSave a screenshot of all screens to the screenshots folder

 

Windows 11 Shortcuts

New shortcuts are introduced with each iteration of Microsoft’s Windows operating system. Below is a list of useful shortcuts specific to Windows 11.

Shortcut KeysDescription
Win + COpen Copilot
Win + SOpen Search
Win + IOpen Windows settings
Win + AOpen Quick Settings
Win + WOpen Widgets.
Win + ZShows window snapping options

After reading through these selected shortcuts, it is clear to see how keyboard shortcuts can save you time.

Top 50 MS Word Shortcuts to Save Time

Let’s now look at the most handy shortcuts in Word, divided into five broad categories. 

Basic shortcuts

ActionWindows/Chrome OS shortcutsMac shortcutWhat it does
Create a new documentCtrl + NCommand + NOpens a new blank document
Open an existing documentCtrl + OCommand + OOpens a dialog box to select a document to open
Save the current documentCtrl + SCommand + SSaves the current document
Close the current documentCtrl + WCommand + WCloses the active document
Undo the last actionCtrl + ZCommand + ZReverses the most recent action
Redo the last undone actionCtrl + YShift + Command + ZReverses the last undone action
Select all textCtrl + ACommand + ASelects all the text in the document

 

 

Shortcuts for navigation

ActionWindows/Chrome OS
shortcuts
Mac shortcutWhat it does
Go to the beginning of the documentCtrl + HomeCommand + Fn+ Left arrow Jumps to the beginning of the document
End of the documentCtrl + EndCommand + Fn+ Right arrowJumps to the end of the document
Beginning of the lineHomeCommand + Left arrowJumps to the beginning of the current line
End of the lineEndCommand + Right arrowJumps to the end of the current line
Go to the next pagePage DownCommand + Page DownMoves to the next page
Previous pagePage UpCommand + Page UpMoves to the previous page
Zoom inCtrl + > or Ctrl + ]Command+Zooms in on the document
Zoom outCtrl + < or Ctrl + [Command+-Zooms out on the document

 

 

Shortcuts for editing text

ActionWindows/Chrome OS shortcutsMac shortcutWhat it does
Cut selected textCtrl + XCommand + XRemoves the selected text and copies it to the clipboard
Copy selected textCtrl + CCommand + CCopies the selected text to the clipboard
Paste from clipboardCtrl + VCommand + VPastes the contents of the clipboard at the current cursor position
Insert a hyperlinkCtrl + KCommand + KOpens the Insert Hyperlink dialog box
Remove formattingCtrl + Shift + NCommand + Shift + NRemoves all formatting from the selected text

 

Shortcuts for formatting text

ActionWindows/Chrome OS shortcutsMac shortcutWhat it does
Bold selected textCtrl + BCommand + BApplies bold formatting to the selected text
Italicize selected textCtrl + ICommand + IApplies italic formatting to the selected text
Underline selected textCtrl + UCommand + UApplies underline formatting to the selected text
Align text to the leftCtrl + LCommand + LAligns the selected text to the left margin
Align text to the centerCtrl + ECommand + ECenters the selected text horizontally
Align text to the rightCtrl + RCommand + RAligns the selected text to the right margin
Increase font sizeCtrl + > or Ctrl + ]Command + >Increases the font size of the selected text
Decrease font sizeCtrl + < or Ctrl + [Command + <Decreases the font size of the selected text
Change font colorCtrl + Shift + FCommand + Shift + COpens the Font dialog box to change the font color
Change fontCtrl + DCommand + DOpens the Font dialog box to change the font style

 

 

Shortcuts for working with tables in Word

ActionWindows/Chrome OS shortcutsMac shortcutWhat it does
Create a tableCtrl + Shift + TCommand + Shift + TInserts a table with the specified number of rows and columns
Insert a rowCtrl + Shift + ICommand + Shift + IInserts a row above the selected row
Insert a columnCtrl + Shift + CCommand + Shift + CInserts a column to the left of the selected column
Delete a rowCtrl + Shift + –Command + Shift + DeleteDeletes the selected row
Delete a columnCtrl + Shift + DeleteCommand + Shift + Right ArrowDeletes the selected column
Merge cellsCtrl + Shift + MCommand + Shift + MMerges the selected cells in a table
Split cellsCtrl + Shift + SCommand + Shift + SSplits the selected cells in a table
Sort tableCtrl + Shift + SCommand + Shift + SSorts the selected table by the specified column
Filter tableCtrl + Shift + LCommand + Shift + LFilters the selected table based on specific criteria

💡 Pro Tip: Read these simple Microsoft Word hacks to optimize your work further.

 

 
 

Top 50 Excel Shortcuts to Save Time

Excel has hundreds of shortcuts, but we’ve handpicked the top 50 that are most commonly used in the workplace. To make things easier, we’ve grouped them by function, like navigating spreadsheets, workbook shortcuts, and formatting cells.

Here are the top 50 Excel shortcuts to save time:

1. Spreadsheet navigation

In this category, we’ll explore shortcuts that let you navigate your spreadsheet entirely without a mouse. These are especially handy when you’re dealing with large or complex spreadsheets.

Sr. No.DescriptionKeyboard shortcuts
1.To move to the next cellTab
2.To move to the previous cellShift + Tab
3.To move one cell downEnter
4.To move one cell upUp arrow key
5.To extend the selection of cells by one cell in that directionShift + Directional Arrow key (Up, Down, Right, or Left)
6.To move to the last cell used in that directionCtrl + Directional Arrow key (Up, Down, Right, or Left)
7.To move to the last used cell on a spreadsheetCtrl + End
8.To move to the first cell on a spreadsheetCtrl + Home
9.To select the entire columnCtrl + Space
10.To select the entire rowShift + Space
11.To select all the used cells in that directionCtrl + Shift + Directional arrow key (Up, Down, Right, or Left)
12.To extend the selection from the active cell to the last used cell on a spreadsheetCtrl + Shift + End
13.To extend the selection from the active cell to the first used cell on a spreadsheetCtrl + Shift + Home
14.To select the entire spreadsheetCtrl + Shift + Spacebar
15.To move to the next sheetCtrl + PageDown
16.To move to the previous sheetCtrl + PageUP
17.To move one screen down in a current sheetPage Down
18.To move one screen up in a current sheetPage Up
19.To move one screen left in a current sheetAlt + Page Down
20.To move one screen right in a current sheetAlt + Page Up

Pro Tip: Use the Mac shortcuts: Command + Shift + $ for quick currency formatting on a Mac. This will instantly format your selected cells as currency in Excel, streamlining your workflow and keeping your financial data organized.

2. Workbook actions

In this category, we’ll cover Excel shortcuts for opening, closing, saving, and other essential actions you perform with a workbook.

Sr. No. DescriptionKeyboard Shortcuts 
21.To create a new workbookCtrl + N
22.To save a workbookCtrl + S
23.To close a current workbookCtrl + W
24.To open an existing workbookCtrl + O
25.To close ExcelCtrl + F4
26.To open the File menuAlt + F
27.To go to the Home tabAlt + H
28.To go to the Insert tabAlt + N
29.To go to the Page LayoutAlt + P
30.To go to the Formulas tabAlt + M
31.To go to the Data tabAlt + A
32.To go to the Review tabAlt + R
33.To go to the View tabAlt + W

3. Quick cell actions

Here, we’ll dive into Excel shortcuts that let you quickly perform actions directly on your worksheet.

Sr. No. DescriptionKeyboard Shortcuts
34.To copy a cell selection in the worksheetCtrl + C
35.To paste a cell selection in the worksheetCtrl + V
36.To cut a cell selection in the worksheetCtrl + X
37.To undo a recent action in the worksheetCtrl + Z
38.To redo a recent action in the worksheetCtrl + Y
39.To open the context menu of a cellShift + F10
40.To insert a functionShift + F3
41.To add a comment in a cellShift + F2
42.To open the Delete dialog boxCtrl + Minus sign
43.To open the Insert dialog boxCtrl + Plus sign
44.To create, delete, or rename a tableCtrl + T, Ctrl + D, or Ctrl + R
45.To add hyperlinkCtrl + K
46.To italicize text or remove italic formattingCtrl + I or Ctrl + 3
47.To apply bold text or remove bold formattingCtrl + B or Ctrl + 2
48.To underline text or remove underlined formattingCtrl + U or Ctrl + F4
49.To fill colorAlt + H + H
50.To check spelling in the active worksheetF7

 Pro Tip: Make Excel reporting more organized by using named ranges. Named ranges make it easier to refer to specific data ranges in your formulas, simplifying your spreadsheet management and making formulas easier to understand.