Use conditional formatting rules in Google Sheets

-
Image
  Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number. On your computer, open a spreadsheet in  Google Sheets . Select the cells you want to apply format rules to. Click  Format     Conditional formatting . A toolbar will open to the right. Create a rule. Single color : Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met. Color scale : Under "Preview," select the color scale. Then, choose a minimum and maximum value, and an optional midpoint value. To choose the value category, click the Down arrow  . Click  Done . Example A teacher can highlight test scores to see which students scored less than 80%. On your computer, open a spreadsheet in  Google Sheets . Select the test scores. Click  Format     Conditional...
Post a Comment

Excel shortcut key

-

Control Functions

ctrl + -  = Delete Row / Column Menu

ctrl + " = Copy above cell values

ctrl + ; = Display date

ctrl + E = Flash Fill

ctrl + Q = Quick Analysis

ctrl + ~ = Show formulas/ values

ctrl + ,,(apostrophe)  = Copy above formula

ctrl + 0 = Hide column

ctrl + 1 =  Format Box

ctrl + 5 = Strike-through

ctrl + 9 = Hide Row

ctrl + A = Select All

ctrl + B or ctrl + 2 = Bold

ctrl + C = Copy

ctrl + D = Fill Down (Copy above)

ctrl + F = Find

ctrl + G or F5 = Go to

ctrl + H = Replace

ctrl + I or ctrl + 3 = Italic

ctrl + k = Insert Hyperlink

ctrl + L or ctrl + T = Create Table

ctrl + U or ctrl + 4 = Underline

ctrl + V = Paste

ctrl + W = Close window

ctrl + X = Cut

ctrl + Y = Repeat/Redo

ctrl + Z = Undo

ctrl + shift + enter = Enter a formula as an array formula

ctrl + Del = Delete text to the end of the line

ctrl + End = Go to the last content

ctrl + Enter = Fill selection entry

ctrl + Alt + V = Paste special box

ctrl + Arrow keys = Go to the end of data range

ctrl + F1 = Min/Restore Ribbon

ctrl + F3 = Name a cell

ctrl + F4 = Close window

ctrl + F9 = Minimize workbook

ctrl + F10 = Maximize window

ctrl + F12 = Open file

ctrl + Home = Move to cell "A1"

ctrl + minus sign = Delete selected cells

ctrl + Pg Up/Down = Switch worksheets

ctrl + Space = Select Column

ctrl + Tab = Switch workbooks

ctrl + [ = Go to precedent cells

ctrl + ] = Go to dependent cells

ctrl + S = Save

ctrl + P = Print

ctrl + Shift + L = Auto Filter


Alt Functions

alt = =  insert autosum formula

alt + down arrow = display a drop - down list 

alt + E + L = delete current worksheet 

alt + E + M = move current worksheet 

alt +  F11 = visual basic editor 

alt + F4 = close program 

alt + F8 = macro box 

alt + O + H + R = rename sheet 

alt + space = control menu 

alt + tab = switch program 

Shift Functions

shift + alt + left arrow = ungroup rows / columns 

shift + alt + right arrow = group rows / columns

shift + arrow keys or page up down = select a cell range 

shift + entre = move to cell above 

shift + F10 =  display shortcut menu 

shift + F10 + m = delete column 

shift + F11 = new worksheet 

shift + F2 = insert a comment 

shift + F3 = insert function box

shift + F4 = find next 

shift + F5 = find / replace dialog box

 shift + F6 = zoom, task, sheet

shift + F7 =  thesaurus

shift + F8 = add to selection 

shift + F9 = calculated active sheet 

shift + spacebar = select row

shift + tab = move to cell to the left 

shift + home = extend the selection to the beginning of the row

When inside cell

alt + entre = start new line in cell ( warp text )

shift + arrow keys = select within cell

ctrl + shift + arrows keys = select contiguous items 

F4 = anchor fix cells

Function keys 

F1 = excel help menu 

F2 = edit cell content

F3 = paste name 

F4 = repeat action 

F5 = go to 

F6 = go to next pane 

F7 = spell check

F8 = anchor cell to select 

F9 = recalculate workbook 

F10 or alt = manu bar ( kep tips )

F11 = new chart 

F12 = save as 

F5 + entre = go back to original cell 

Misc  functions    

tab = move to cell to the right 

window + D = minimize program

window + E = window explorer 

home =  go to beginning of line

entre = move to cell bellow 

Arrows keys = move to new cell 

=  ( equals sign ) or + ( plus sign ) = start a formula 

Formatting Function 

ctrl + shift +! = number format
ctrl + shift + # = date format 
ctrl + shift + $ = currency format 
ctrl + shift + format = percentage format 
ctrl + shift + & = outline border
ctrl + shift + *  = select active region
ctrl +shift +; = display time 
ctrl + shift + @ = time format 
ctrl + shift + ^ = scientific format 
ctrl + shift + _ =  remove border 
ctrl + shift  + { = trace all precedents ( indirect ) 
ctrl + shift + } \= trace all dependents ( indirect ) 
ctrl + shift + ~ = general format
ctrl + shift + " = copy value from above cell 
ctrl + shift + + = insert row / column menu 
ctrl + shift + 0 =  unhide column 
ctrl ++ shift +9  = unhide row 
ctrl +shift + arrows keys =  select contiguous range 
ctrl + shift + entre = entre array formula 
ctrl ++ shift + F3 = create names from selection 
ctrl + shift + o = select cell with comment 
ctrl + shift + pg up / dn = select multiple sheets 
ctrl + shift + end = extend the selection  to the last used cell on the sheet 
ctrl + shift + home =  extend selection to the beginning of the sheet


Comments

Post a Comment

Popular posts from this blog

HLOOKUP Function in Excel With Example

-
Image
  HLOOKUP in Excel – With Examples HLOOKUP function  in Excel is a sibling of the VLOOKUP function. The  H  in the HLOOKUP stands for “Horizontal” and hence it is often called Horizontal Lookup. HLOOKUP is a very useful function for creating horizontal lookups, but as most of the tables that we deal with are vertical hence this function is not very popular. The task of the HLOOKUP function is to search for a value in the topmost row of a table, and then return a corresponding value in the same column from a row you specify. Definition and Syntax of HLOOKUP Function in Excel Microsoft Excel defines HLOOKUP as a function that “looks for a value in the top row of a table or array of values and returns the value in the same column from a row you specify”. Syntax of Excel HLOOKUP The syntax of the HLOOKUP function in Excel is as follows: =HLOOKUP(lookup_value,table_array,row_index_number,range_lookup) How to Use HLOOKUP in Excel Now, let’s understand how to use this ...
Read more

Use conditional formatting rules in Google Sheets

-
Image
  Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number. On your computer, open a spreadsheet in  Google Sheets . Select the cells you want to apply format rules to. Click  Format     Conditional formatting . A toolbar will open to the right. Create a rule. Single color : Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met. Color scale : Under "Preview," select the color scale. Then, choose a minimum and maximum value, and an optional midpoint value. To choose the value category, click the Down arrow  . Click  Done . Example A teacher can highlight test scores to see which students scored less than 80%. On your computer, open a spreadsheet in  Google Sheets . Select the test scores. Click  Format     Conditional...
Read more