CCC LIBREOFFICE CALC SHORTCUT KEYS
Table of Contents
CCC LIBREOFFICE CALC SHORTCUT KEYS
CCC LIBREOFFICE CALC SHORTCUT KEYS:-लिब्रे ऑफिस calc एक ओपन सोर्स फ्री सॉफ्टवेयर है जो कि माइक्रोसॉफ्ट एक्सेल का एक बहुत अच्छा विकल्प है । ms ऑफिस एक्सेल की तरह ही लिब्रे ऑफिस calc में वे सभी विशेषताएं पायी जाती हैं जो की किसी प्रोफेशनल सॉफ्टवेयर में होनी चाहिए। लिब्रे ऑफिस calc में real time में अलग अलग जगह की spreadsheet को merage भी किया जा सकता है । ms excel की फाइल को लिब्रे ऑफिस calc में open किया जा सकता है । चूंकि libreoffice calc एक open source फ्री software हैं इसी कारण से इसे CCC के syllabus में शामिल किया गया है ।
आज अपनी इस पोस्ट में हम लिब्रेऑफिस calc में प्रयोग की जाने वाली शॉर्टकट keys को अलग अलग tabwise समझेंगे ।
LIBREOFFICE CALC KEYBOARD SHORTCUTS WITH EXPLANATION
INFORMATION TECHNOLOGY NOTES
FILE MENU
CTRL + N – To New Sheet
CTRL + Shift + N – To Manage Templates
CTRL + O – To open Previous Saved File
Shift + F11 – To save a Template
CTRL + S – To save a file
CTRL + Shift + S – To Save As
CTRL + Enter – To Next Line
CTRL + Shift + O – To Print Preview
CTRL + Q – To Exit Libreoffice
EDIT MENU
CTRL + X – To cut
CTRL + C – To Copy
CTRL + V – To Paste
CTRL + Z – To Undo
CTRL + Y – To Redo
CTRL + Shift + Y – To Repeat
CTRL + Shift + V – To Paste Special
CTRL + Alt + Shift + V – To Paste Unformatted Text
CTRL + Shift + Spacebar – To Select All
CTRL + PageDn / CTRL + Tab – To Go To Next Sheet
CTRL + PageUp / CTRL + Shift + Tab – To Go To Previous Sheet
Shift + Spacebar – To Select Row
CTRL + Spacebar – To Select Column
CTRL + * – To Select Data Area
F2 – To Edit Cell
CTRL + Shift + M – To Edit Mode
CTRL + H – To Find and Replace
CTRL + F – To Find
OPERATING SYSTEM NOTES
VIEW MENU
CTRL + F8 – To Value Highlighting
CTRL – To Show Formula
CTRL + F5 – To Show / Hide Sidebar
F11 – To Show / Hide Styles
F5 – To Open Navigator
CTRL + Shift + J – To Full Screen
CTRL + Shift + F4 – To Data Source Hide/Show
INSERT MENU
CTRL + F2 – To Insert Function
CTRL + Alt + C – To Comments
CTRL + K – To Hyperlink
CTRL + ; – To Date
CTRL + Shift + ; – To Time
MS WORD NOTES
FORMAT MENU
CTRL + B – To Bold
CTRL + I – To Italic
CTRL + U – To Underline
CTRL + Shift +P – To Superscript
CTRL + Shift + B – To Subscript
CTRL + 5 – To 1.5 Line Spacing
CTRL + 2 – To 2 Line Spacing
CTRL + L – To Left Alignment
CTRL + E – To Centre Alignment
CTRL + J – To Justified Alignment
CTRL + ] – To Increase Size
CTRL – [ – To Decrease
CTRL + D – To Double Under Line
CTRL + Shift + 6 – To General Format
CTRL + Shift + 1 – To Number Format
CTRL + Shift + 5 – To Percent Format
CTRL + Shift + 4 – To Currency Format
CTRL + Shift + 3 – To Date Format
CTRL + Shift + 2 – To Scientific
CTRL + M – To Clear Formatting
CTRL + 1 – To Cell Formatting
CCC LIBREOFFICE CALC SHORTCUT KEYS
STYLE MENU
F11 – To Manage Styles
EXCEL NOTES
SHEET MENU
CTRL + + – To Insert cell
CTRL + – – To Delete cell
Backspace – To Clear Cells
F4 – To Cycle Cell Reference Type
CTRL + D – To Fill Down
CTRL + ALT + C – To Edit Comment
CTRL + Shift + Tab – To Previous Sheet
CTRL + Tab – To Next Sheet
CTRL + F3 – To Manage Names
Tab – Go To Next Cell
Shift + Tab – Go To Previous Cell
CCC LIBREOFFICE CALC SHORTCUT KEYS
DATA MENU
CTRL + Shift + F9 – To Recalculate Hard
F9 – To Recalculate
F12 – To Group
CTRL + F12 – To Ungroup
CCC LIBRE OFFICE CALC SHORTCUT KEYS
POWERPOINT NOTES
TOOLS MENU
F7 – To Spelling
Shift + F7 – To Automatic Spelling Check
CTRL + F7 – To Thesaurus
Shift + F9 – To Trace Precedents
Shift + F5 – To Trace Dependents
CTRL + ALT + E – To Extension Manager
WINDOW MENU
CTRL + W – To Close Window
HELP MENU
F1 – To Help
SPECIAL SHORTCUT KEYS FOR LIBRE OFFICE CALC
SHORTCUT ACTION
Ctrl + Home – To Move cursor to A1
Ctrl + End – To Move cursor to last cell with data inside
Home – To Move cursor to first cell of the row
End – To Move cursor to last cell of the row
Shift + Home – To Select from current cell to first cell of the row
Shift + End – To Select from current cell to last cell of the row
Shift + Page up – To Select from the current cell up a page
SHORTCUT ACTION
Shift + Page down – To Select from the current cell down a page
Ctrl + Left arrow – To Move cursor left of the current data range
Ctrl + Right arrow – To Move cursor right of the current data range
Ctrl + Up arrow – To Move cursor to the top of the current data range
Ctrl + Down arrow – To Move cursor to the bottom of the current data range
Ctrl + Shift + Arrow – To Select all cells containing data, in the direct of the arrow
Ctrl + Page up – To Move sheet right
Ctrl + Page down – To Move sheet right
Alt + Page up – To Move one screen left
Alt + Page down – To Move one screen right
Alt + Down arrow – To Increase current height row
Alt + Up arrow – To Decrease current height row
CCC LIBRE OFFICE CALC SHORTCUT KEYS
SHORTCUT ACTION
Alt + Right arrow – To Increase current column width
Alt + Left arrow – To Decrease current column width
Alt + Shift + Arrow – To Fits column width and row height based on current cell
Shift + Ctrl + Page up – To Adds previous sheet to current sheet
Shift + Ctrl + Page down- To Adds next sheet to current sheet
Ctrl + * – To Selects data range contained by the cursor
Ctrl + / – To Selects matrix formula contained by the cursor
Ctrl + Plus – To Insert cells
Ctrl + Minus – To Delete cells
Enter – To Move cursor one cell down
Ctrl + ` – To Display/hide formulas
SHORTCUT ACTION
Formatting
Ctrl + 1 – To Open Format cells
Ctrl + Shift + 1 – To Two decimal places
Ctrl + Shift + 2 – To Exponential format
Ctrl + Shift + 3 – To Date format
Ctrl + Shift + 4 – To Currency format
Ctrl + Shift + 5 – To Percentage format
Ctrl + Shift + 6 – To Standard format
INTERNET NOTES
Functions
Ctrl + F1 – To Show comment
F2 – To Enter Edit mode
Ctrl + F2 – To Open Function wizard
Shift + Ctrl + F2 – To Move cursor to input line
TALLY WITH SHORTCUT KEYS NOTES
SHORTCUT ACTION
Ctrl + F3 – To Open Define names
Shift + Ctrl + F4 – To Show/hide Database explorer
F4 – To Rearrange references
F5 – To Show/hide Navigator
Shift + F5 – To Traces dependents
Shift + Ctrl + F5 – To Moves cursor to Sheet area
F7 – To Check spelling
Shift + F7 – To Traces precedents
Ctrl + F7 – To Opens Thesaurus
F8 – To Enable/disable additional selection mode
Ctrl + F8 – To Highlight cells containing values
F9 – To Recalculate formulas in current sheet
Ctrl + F9 – To Update chart
Ctrl + Shift + F9 – To Recalculate formulas in all sheets
SHORTCUT ACTION
F11 – To Open Styles
Shift + F11 – To Create a document template
Shift + Ctrl + F11 – To Update the template
F12 – To Group the selected data range
Ctrl + F12 – To Ungroup the selected data range
TO BE CONTINUED IN NEXT POST……
अंत में
Conclusion (निष्कर्ष) :- मुझे पूरी आशा हैं कि आपको मेरे द्वारा LIbre office पर दी गई संक्षिप्त जानकारी पसंद आयी होगी ।
आज अपनी इस post में हमने LIbre office CALC के विभिंन shortcut keys को cover किया हैं । यदि आप मेरे मार्गदर्शन के रूप में मुझे कुछ सुझाव देना चाहे तो कृपया Comment Box में अपने विचार व्यक्त अवश्य करें ।
आपके विचारो के माध्यम से ही मैं अपने कार्य को और भी न्यायसंगत तथा सुविधाजनक बना सकूँगा ।