Fungsi Clear Formatting

ClearFungsi Clear FormattingFungsi

Silahkan baca: Fungsi Filter Pada Excel Dan Cara Membuatnya. Dalam menu delete cell dan format cell ini ada beberapa kategori pilihan yang bisa kita gunakan dalam membuat data di Ms Excel, untuk lebih jelasnya mari kita bahas satu persatu fungsi apa saja yang bisa kita gunakan dalam kedua menu ini.

Excel Shortcuts

  • Some say “Mylar” when they mean polyester film or plastic sheet. Really, Mylar is a trademark registered by Dupont Tejjin Films for specific plastic sheet products made from Polyethylene Terephthalate (PET) resin. Grafix sells many types, grades, finishes and thicknesses. Contact us to learn about Mylar applications.
  • Beberapa Icon dan fungsi di Group Editing: a. AutoSum (Alt+=): Untuk menjumlah isi sel yang dipilih. Fill: Untuk membuat deret data dalam suatu range, menyalin isi data suatu sel atau range. Clear: Untuk menghapus semuanya dari sel, nilai hingga format.

Below are 215 of the best Excel shortcuts (tested on Excel 2010, but 95% useable in Excel 2013 as well).

Download them in Excel – FREE!

Formatting

Terminology:

Fungsi Clear Formatting Tool

SignMeaning
+Press keys simultaneously
Press keys in succession
,Begin a new sequence
RCRight-Click
RDRight-Drag
<###>Click on ### in context menu
MKMenu Key
DCDouble Click

Fungsi Dari Clear Formatting

Background

Fungsi Clear Formatting Definition

CategoryTaskExcel Shortcut
Alt-AClear FilterAlt-A-C
Alt-AFilterAlt-A-T
Alt-ARefresh ConnectionsAlt-A-R
Alt-AAdvanced FilterAlt-A-Q
Alt-AGroupAlt-A-G-G
Alt-ASort AscendingAlt-A-S-A
Alt-ASort DescendingAlt-A-S-D
Alt-AText To ColumnsAlt-A-E
Alt-ACustom SortAlt-A-S-S
Alt-AData ValidationAlt-A-V
Alt-AGet External Data Existing ConnectionsAlt-A-X
Alt-ASubtotalAlt-A-B
Alt-AWhat-If AnalysisAlt-A-W
Alt-AGet External Data From AccessAlt-A-F-A
Alt-AGet External Data From TextAlt-A-F-T
Alt-AGet External Data From WebAlt-A-F-W
Alt-EDelete (#1)Alt-E-D
Alt-EFind/ReplaceAlt-E-E
Alt-EClear AllAlt-E-A-A
Alt-EClear Contents (#1)Alt-E-A-C
Alt-EClear FormatsAlt-E-A-F
Alt-EDelete WorksheetAlt-E-L
Alt-EPaste Special Pop-Up Menu (#1)Alt-E-S
Alt-FRecent Files (To Open)Alt-F-R
Alt-FSave (#2)Alt-F-S
Alt-FClose Workbook (#2)Alt-F-C
Alt-FExit Excel (#1)Alt-F-X
Alt-FSave As (#1)Alt-F-A
Alt-FOptionsAlt-F-T
Alt-FSave & SendAlt-F-D-A
Alt-RNew Comment (#1)Alt-R-C
Alt-RDelete CommentAlt-R-D
Alt-REdit Comment (#1)Alt-R-T
Alt-RNew Comment (#2)Shift+F2
Alt-RResearch (#2)Alt+Click
Alt-RSpelling (#1)Alt-R-S
Alt-RSpelling (#2)F7
Alt-REdit Comment (#2)Shift+F2
Alt-RPrevious CommentAlt-R-V
Alt-RResearch (#1)Alt-R-R
Alt-RShare WorkbookAlt-R-W
Alt-RShow All CommentsAlt-R-A
Alt-RThesaurusAlt-R-E
Alt-RTrack ChangesAlt-R-G
Alt-WSwitch WindowsAlt-W-W
Alt-WFreeze PanesAlt-W-F-F
Alt-WArrange AllAlt-W-A
Alt-WCustom ViewsAlt-W-C
Alt-WFull ScreenAlt-W-E
Alt-WSplitAlt-W-S
Alt-WView Side By SideAlt-W-B
Alt-WZoom (With Presets)Alt-W-Q
Alt-WZoom To SelectionAlt-W-G
Alt-WHide/Show Formula BarAlt-W-V-F
Alt-WView GridlinesAlt-W-V-G
Basic FormattingBold (#1)Ctrl+B
Basic FormattingBold (#2)Ctrl+2
Basic FormattingCopy & Paste FormatsFormat Painter (double-click for repeated pastes)
Basic FormattingItalics (#1)Ctrl+I
Basic FormattingUnderline (#2)Ctrl+4
Basic FormattingItalics (#2)Ctrl+3
Basic FormattingUnderline (#1)Ctrl+U
Basic Navigation & SelectionExtend Selection By One Cell/Row/ColumnShift+Arrow
Basic Navigation & SelectionJump To Edge Of Blank(S)Ctrl+Arrow
Basic Navigation & SelectionMove One CellArrow
Basic Navigation & SelectionSelect RegionCtrl+A
Basic Navigation & SelectionJump To & Select Through Edge Of RegionCtrl+Shift+Arrow
Columns & RowsDelete Column(S) Or Row(S) Once SelectedRC-D
Columns & RowsExtend Selection To A Range Of Columns/RowsCtrl+Spacebar (or Shift+Spacebar), then Shift+Arrow until you’re at end of range
Columns & RowsSelect A Range Of Columns/Rows (#1)click on first header & hold while moving mouse across to end
Columns & RowsSelect A Range Of Columns/Rows (#2)click on first header, then click on end header while holding down Shift
Columns & RowsSelect Entire Column / RowCtrl+Spacebar / Shift+Spacebar
Columns & RowsSelect Entire Column/Rowclick on column letter / row number
Columns & RowsDelete Selected Column(S)/Row(S)Ctrl+- (yes, Ctrl, followed by ‘-‘)
Columns & RowsInsert Column(S) Or Row(S) Once Selected (#1)Ctrl++ (or Ctrl+Shift+=)
Columns & RowsInsert Column(S) Or Row(S) Once Selected (#2)RC-I
Context 1 & 2Delete (#2)RC-D
Context 1 & 2Format Cells Dialog BoxRC-F (or RC-F-F-Spacebar depending on context)
Context 1 & 2Paste Values (#2)RC-V
Context 1 & 2Insert Copied CellsRC-E Spacebar (or RC-E depending on context)
Context 1 & 2Paste Formatting (#1)RC-R (or RC-R-Spacebar depending on context)
Context 1 & 2Paste Special Sub-Menu (#2)RC-S
Context 1 & 2Row HeightRC-R (or RC-R-R-Spacebar depending on context)
Context 1 & 2Clear Contents (#2)Click on Context Menu option
Context 1 & 2Hide And UnhideClick on Context Menu option
Context 1 & 2InsertClick on Context Menu option
Cut, Copy & PasteCopyCtrl+C
Cut, Copy & PastePasteCtrl+V
Cut, Copy & PasteCutCtrl+X
Find & ReplaceFindCtrl+F
Find & ReplaceReplace (#2)Alt-E-E
Find & ReplaceReplace (#1)Ctrl+H
Formatting IIPaste Formatting (#1)RC-R (F4 for repeated pastes)
Formatting IIIFormat Cells Dialog BoxCtrl+1
Formatting IIICreate BordersCtrl+Shift+7
Formatting IIICurrency FormatCtrl+Shift+4
Formatting IIIPercent FormatCtrl+Shift+5
Formatting IIIRemove BordersCtrl+Shift+-
Formatting IIIFont SizeCtrl+Shift+P
Formatting IIIFont StyleCtrl+Shift+F
Formatting IIIComma Format (W/ 2 Decimals)Ctrl+Shift+1
Formatting IIIDate FormatCtrl+Shift+3
Formatting IIIGeneral FormatCtrl+Shift+` (accent grave)
Formatting IIITime FormatCtrl+Shift+2
Formatting IIIExponential FormatCtrl+Shift+6
Jumping To CellsGo Back To Most Recent Cell (#1)Ctrl+G, then Enter
Jumping To CellsGo Back To Most Recent Cell (#2)F5, then Enter
Jumping To CellsGo To Specific Cell (#2)F5, input cell reference, Enter
Jumping To CellsGo To Direct Precedents / DependentsCtrl+[ / Ctrl+]
Jumping To CellsGo To Specific Cell (#1)Ctrl+G, input cell reference, Enter
Jumping To CellsGo To Direct & Indirect Precedents / DependentsCtrl+Shift+[ / Ctrl+Shift+]
Jumping To CellsSelect Everything Between Current and Specified Cell (#1)Ctrl+G, input cell reference, Shift+Enter
Jumping To CellsSelect Everything Between Current and Specified Cell (#2)F5, input cell reference, Shift+Enter
MiscellaneousClose Workbook (#1)Ctrl+W
MiscellaneousDelete WorksheetAlt-E-L
MiscellaneousAutofit Column Width (Or Row Height)DC right/bottom border of column/row
MiscellaneousCreate Chart On Same TabAlt+F1
MiscellaneousExit Excel (#2)Alt+F4
MiscellaneousExplode Pivot DetailDC pivot data
MiscellaneousHide ColumnsCtrl+0
MiscellaneousHide RowsCtrl+9
MiscellaneousNew WorkbookCtrl+N
MiscellaneousNew WorksheetShift+F11
MiscellaneousOpen WorkbookCtrl+O
MiscellaneousSave As (#2)F12
MiscellaneousUnhide ColumnsCtrl+Shift+0
MiscellaneousUnhide RowsCtrl+Shift+9
MiscellaneousAutofill / Automatically Extend SequenceDrag or DC fill handle of selected sequence
MiscellaneousCreate Chart On New TabF11
MiscellaneousCreate Table (#1)Ctrl+T
MiscellaneousCreate Table (#2)Ctrl+L
MiscellaneousEntering Characters In A Row (Vs. A Column)Hit Tab instead of Enter
MiscellaneousHelpF1
MiscellaneousPaste Name Dialog BoxF3
MiscellaneousPrintCtrl+P
MiscellaneousRename WorksheetDC tab name, then change name
MiscellaneousCopy Formula From AboveCtrl+’ (apostrophe)
MiscellaneousCopy Only Visible CellsAlt+; (after selecting, but before copying )
MiscellaneousCopy Value From AboveCtrl+Shift+’ (apostrophe)
MiscellaneousHide RibbonCtrl+F1
MiscellaneousInsert Current DateCtrl+;
MiscellaneousInsert Current TimeCtrl+Shift+;
MiscellaneousInsert Current Date And TimeCtrl+; , Spacebar, Ctrl+Shift+;
Moving Between Wkshts/Wkbks/WinGo To Most Recent WorkbookAlt+Tab+Tab if in Excel; Alt+Tab if not in Excel, but Excel was most recent window
Moving Between Wkshts/Wkbks/WinOpen Switch Windows Drop-DownAlt-W-W
Moving Between Wkshts/Wkbks/WinRotate Fwd/Bkwd Between Open Programs/WindowsAlt+Tab / Alt+Shift+Tab (keep tapping Tab key)
Moving Between Wkshts/Wkbks/WinGo To Next/Previous Open Excel FileCtrl+Tab / Ctrl+Shift+Tab
Moving Between Wkshts/Wkbks/WinMove Right /Left to Next TabCtrl+PgDn/PgUp
Moving Between Wkshts/Wkbks/WinSelect Multiple Adjacent / Non-Adjacent WorksheetsShift+Click / Ctrl+Click on tabs
Moving Between Wkshts/Wkbks/WinJump To Tab (Good When Many Tabs)RC on tab navigation arrows, then select tab
Navigating Dialog BoxesEnter A TabTab
Navigating Dialog BoxesGo To Next / Previous Option In TabTab / Shift+Tab
Navigating Dialog BoxesCheck/Unchecks BoxSpacebar
Navigating Dialog BoxesFinalize SelectionsEnter
Navigating Dialog BoxesGo To Next / Previous Tab (#1)Ctrl+Tab / Ctrl+Shift+Tab
Navigating Dialog BoxesGo To Next / Previous Tab (#2)Ctrl+Letter (if underlined letter)
Navigating Dialog BoxesGo To Next / Previous Tab (#3)First letter (if no underlined letter)
Navigating Dialog BoxesGo To Next / Previous Tab (#4)←→ (if no underlined letter)
Navigating Dialog BoxesGo To Next/Previous Option←→ (…but can get stuck)
Navigating Dialog BoxesNavigate Dropdowns↑↓ or first letter (Enter or Tab selects option; ESC exits dropdown with no change)
Navigating Dialog BoxesGo To Option w/ Underlined LetterAlt+Letter (Checkbox items will be checked; Alt+Letter again will uncheck)
Navigating Dialog BoxesGo To Radio Button W/Underlined LetterLetter
Navigation & Selection For Big DataSelect regionCtrl+A
Navigation & Selection For Big DataSelect Region & Move Viewpoint To Last CellCtrl+A (from 1st cell in region)
Navigation & Selection For Big DataZoom In/Out (For Inspection)Ctrl+spin mouse wheel
Navigation & Selection For Big DataGo To Cell A1Ctrl+Home
Navigation & Selection For Big DataSelect Entire SheetCtrl+(A-A)
Navigation & Selection For Big DataSelect Through “Last Used Cell”Ctrl+Shift+End
Navigation & Selection For Big DataGo To Cell A1, Select Region & View Last CellCtrl+(Home-A)
Navigation & Selection For Big DataSelect Through Next BorderCtrl+Shift+Arrow
Navigation & Selection For Big DataSelect (Remote) RegionCtrl+* (or Ctrl+Shift+8)
Navigation & Selection For Big DataSelect (Remote) Region & View Last CellCtrl+ *-↑-↓, Ctrl+A
Navigation & Selection For Small DataSelect Contiguous RegionClick on first cell, then Shift-Click on end cell
Navigation & Selection For Small DataSelect Non-Contiguous Cells Or RegionSelect first region; press Ctrl while selectiong add’l regions
Paste SpecialPaste Values (#1)RC-V
Paste SpecialPaste Formatting (#1)RC-R
Paste SpecialPaste Special Sub-Menu (#1)RC-S
Paste SpecialPaste Special – Values & Number FormatsRC-S-A
Paste SpecialPaste Special Pop-Up Menu (#1)Alt-E-S
Paste SpecialPaste Special Pop-Up Menu (#2)RC-S-S
Paste SpecialPaste Formula (#1)RC-F-spacebar
Paste SpecialPaste Formula (#2)RC-S-F
Paste SpecialTransposeRC-S-T
Paste SpecialPaste Special Sub-Menu (W/ Screen Tips)Alt-H-V
Paste SpecialAdd Zero For Text –> Number FormatRC-S-S-V-D-
Paste SpecialPaste Link (#1)RC-
Paste SpecialPaste Link (#2)RC-N-Spacebar
Paste SpecialCopy And Paste Column WidthsRC-S-S-W-Enter
Paste SpecialMultiply Cells By 1000RC-S-S-V–
Paste SpecialPaste Special — Picture (#1)RC-S-U
Paste SpecialPaste Special — Picture (#1)RC-S-
Right-DragCopy And PasteDrag selection, release, all while pressing Ctrl
Right-DragCut And PasteDrag selection, release at destination
Right-DragCopy & PasteRD-C
Right-DragConvert To Values “Wiggle”RD-V (back onto copied selection)
Right-DragCopy & Paste ValuesRD-V
Right-DragInsert Copied Cells & Shift DownRD-S
Right-DragInsert Copied Cells & Shift RightRD-T
Right-DragPaste Formatting (#2)RD-F
Right-DragInsert Cut Cells & Shift DownRD-D
Right-DragInsert Cut Cells & Shift RightRD-R
SaveSave (#1)Ctrl+S
Undo & RedoUndoCtrl+Z
Undo & RedoRedo (#2)F4
Undo & RedoRedo (#1)Ctrl+Y
Working With FormulasCopy Formula One Cell AcrossCtrl+R
Working With FormulasCopy Formula One Cell DownCtrl+D (will copy cell just above it)
Working With FormulasEdit Formula, Get Visual On Formula References (#2)Double-click formula cell
Working With FormulasCopy Down Formula To End Of Adjacent ColumnDouble-Click “Fill Handle” (bottom right corner of cell)
Working With FormulasCopy Down/Across Formula (#1)Drag cell by Fill Handle
Working With FormulasEdit Formula, Get Visual On Formula References (#1)F2 on formula cell
Working With FormulasAutosumAlt+=
Working With FormulasCancel Formula EditingESC
Working With FormulasLock Cell References / Rotate Through OptionsF4 (while in Edit Mode) / repeat F4 as needed
Working With FormulasCopy Down/Across Formula (#3)Select range, type formula, hit Ctrl+Enter
Working With FormulasFaster Formula EntryBegin with ‘+’ instead of ‘=’
Working With FormulasFaster Formula Entry (With Functions)Type first letters of function, Tab, enter arguments, Enter
Working With FormulasCopy Down/Across Formula (#2)Ctrl+C, select target cells, Ctrl+V
Working With FormulasCopy Down/Across Formula (#4)Select range (first cell must be the one to be copied), then Ctrl+D / Ctrl+R
Working With FormulasDisplay All Formulas Instead Of ValuesCtrl+`
Working With FormulasFind Bottom Of Column, Then Copy Down FormulaGo to bottom, Ctrl+Shift+↑,Ctrl+D
Working With FormulasRecalculate All Formulas In WorkbookF9
Working With FormulasRecalculate Formulas In Open Worksheet OnlyShift+F9