\documentclass[10pt,a4paper]{article} % Packages \usepackage{fancyhdr} % For header and footer \usepackage{multicol} % Allows multicols in tables \usepackage{tabularx} % Intelligent column widths \usepackage{tabulary} % Used in header and footer \usepackage{hhline} % Border under tables \usepackage{graphicx} % For images \usepackage{xcolor} % For hex colours %\usepackage[utf8x]{inputenc} % For unicode character support \usepackage[T1]{fontenc} % Without this we get weird character replacements \usepackage{colortbl} % For coloured tables \usepackage{setspace} % For line height \usepackage{lastpage} % Needed for total page number \usepackage{seqsplit} % Splits long words. %\usepackage{opensans} % Can't make this work so far. Shame. Would be lovely. \usepackage[normalem]{ulem} % For underlining links % Most of the following are not required for the majority % of cheat sheets but are needed for some symbol support. \usepackage{amsmath} % Symbols \usepackage{MnSymbol} % Symbols \usepackage{wasysym} % Symbols %\usepackage[english,german,french,spanish,italian]{babel} % Languages % Document Info \author{A. (dreamsofpdx)} \pdfinfo{ /Title (excel.pdf) /Creator (Cheatography) /Author (A. (dreamsofpdx)) /Subject (Excel Cheat Sheet) } % Lengths and widths \addtolength{\textwidth}{6cm} \addtolength{\textheight}{-1cm} \addtolength{\hoffset}{-3cm} \addtolength{\voffset}{-2cm} \setlength{\tabcolsep}{0.2cm} % Space between columns \setlength{\headsep}{-12pt} % Reduce space between header and content \setlength{\headheight}{85pt} % If less, LaTeX automatically increases it \renewcommand{\footrulewidth}{0pt} % Remove footer line \renewcommand{\headrulewidth}{0pt} % Remove header line \renewcommand{\seqinsert}{\ifmmode\allowbreak\else\-\fi} % Hyphens in seqsplit % This two commands together give roughly % the right line height in the tables \renewcommand{\arraystretch}{1.3} \onehalfspacing % Commands \newcommand{\SetRowColor}[1]{\noalign{\gdef\RowColorName{#1}}\rowcolor{\RowColorName}} % Shortcut for row colour \newcommand{\mymulticolumn}[3]{\multicolumn{#1}{>{\columncolor{\RowColorName}}#2}{#3}} % For coloured multi-cols \newcolumntype{x}[1]{>{\raggedright}p{#1}} % New column types for ragged-right paragraph columns \newcommand{\tn}{\tabularnewline} % Required as custom column type in use % Font and Colours \definecolor{HeadBackground}{HTML}{333333} \definecolor{FootBackground}{HTML}{666666} \definecolor{TextColor}{HTML}{333333} \definecolor{DarkBackground}{HTML}{14960F} \definecolor{LightBackground}{HTML}{F7FBF7} \renewcommand{\familydefault}{\sfdefault} \color{TextColor} % Header and Footer \pagestyle{fancy} \fancyhead{} % Set header to blank \fancyfoot{} % Set footer to blank \fancyhead[L]{ \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{C} \SetRowColor{DarkBackground} \vspace{-7pt} {\parbox{\dimexpr\textwidth-2\fboxsep\relax}{\noindent \hspace*{-6pt}\includegraphics[width=5.8cm]{/web/www.cheatography.com/public/images/cheatography_logo.pdf}} } \end{tabulary} \columnbreak \begin{tabulary}{11cm}{L} \vspace{-2pt}\large{\bf{\textcolor{DarkBackground}{\textrm{Excel Cheat Sheet}}}} \\ \normalsize{by \textcolor{DarkBackground}{A. (dreamsofpdx)} via \textcolor{DarkBackground}{\uline{cheatography.com/145411/cs/31318/}}} \end{tabulary} \end{multicols}} \fancyfoot[L]{ \footnotesize \noindent \begin{multicols}{3} \begin{tabulary}{5.8cm}{LL} \SetRowColor{FootBackground} \mymulticolumn{2}{p{5.377cm}}{\bf\textcolor{white}{Cheatographer}} \\ \vspace{-2pt}A. (dreamsofpdx) \\ \uline{cheatography.com/dreamsofpdx} \\ \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Cheat Sheet}} \\ \vspace{-2pt}Published 24th March, 2022.\\ Updated 24th March, 2022.\\ Page {\thepage} of \pageref{LastPage}. \end{tabulary} \vfill \columnbreak \begin{tabulary}{5.8cm}{L} \SetRowColor{FootBackground} \mymulticolumn{1}{p{5.377cm}}{\bf\textcolor{white}{Sponsor}} \\ \SetRowColor{white} \vspace{-5pt} %\includegraphics[width=48px,height=48px]{dave.jpeg} Measure your website readability!\\ www.readability-score.com \end{tabulary} \end{multicols}} \begin{document} \raggedright \raggedcolumns % Set font size to small. Switch to any value % from this page to resize cheat sheet text: % www.emerson.emory.edu/services/latex/latex_169.html \footnotesize % Small font. \begin{multicols*}{2} \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{One and Two Key Commands}} \tn % Row 0 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}{\bf{Key}}} \tn % Row Count 1 (+ 1) % Row 1 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F1} \tn % Row Count 2 (+ 1) % Row 2 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F2} \tn % Row Count 3 (+ 1) % Row 3 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F3} \tn % Row Count 4 (+ 1) % Row 4 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F4} \tn % Row Count 5 (+ 1) % Row 5 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F5} \tn % Row Count 6 (+ 1) % Row 6 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F6} \tn % Row Count 7 (+ 1) % Row 7 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F7} \tn % Row Count 8 (+ 1) % Row 8 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F8} \tn % Row Count 9 (+ 1) % Row 9 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F9} \tn % Row Count 10 (+ 1) % Row 10 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F10} \tn % Row Count 11 (+ 1) % Row 11 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F11} \tn % Row Count 12 (+ 1) % Row 12 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F12} \tn % Row Count 13 (+ 1) % Row 13 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}A} \tn % Row Count 14 (+ 1) % Row 14 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}B} \tn % Row Count 15 (+ 1) % Row 15 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}C} \tn % Row Count 16 (+ 1) % Row 16 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}D} \tn % Row Count 17 (+ 1) % Row 17 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}F} \tn % Row Count 18 (+ 1) % Row 18 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}G} \tn % Row Count 19 (+ 1) % Row 19 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}H} \tn % Row Count 20 (+ 1) % Row 20 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}I} \tn % Row Count 21 (+ 1) % Row 21 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}K} \tn % Row Count 22 (+ 1) % Row 22 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}L} \tn % Row Count 23 (+ 1) % Row 23 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}M} \tn % Row Count 24 (+ 1) % Row 24 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}N} \tn % Row Count 25 (+ 1) % Row 25 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}O} \tn % Row Count 26 (+ 1) % Row 26 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}P} \tn % Row Count 27 (+ 1) % Row 27 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}R} \tn % Row Count 28 (+ 1) % Row 28 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}S} \tn % Row Count 29 (+ 1) % Row 29 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}T} \tn % Row Count 30 (+ 1) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{One and Two Key Commands (cont)}} \tn % Row 30 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}U} \tn % Row Count 1 (+ 1) % Row 31 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}V} \tn % Row Count 2 (+ 1) % Row 32 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}W} \tn % Row Count 3 (+ 1) % Row 33 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}X} \tn % Row Count 4 (+ 1) % Row 34 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Y} \tn % Row Count 5 (+ 1) % Row 35 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Z} \tn % Row Count 6 (+ 1) % Row 36 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}0} \tn % Row Count 7 (+ 1) % Row 37 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}1} \tn % Row Count 8 (+ 1) % Row 38 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}2} \tn % Row Count 9 (+ 1) % Row 39 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}3} \tn % Row Count 10 (+ 1) % Row 40 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}4} \tn % Row Count 11 (+ 1) % Row 41 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}5} \tn % Row Count 12 (+ 1) % Row 42 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}6} \tn % Row Count 13 (+ 1) % Row 43 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}8} \tn % Row Count 14 (+ 1) % Row 44 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}9} \tn % Row Count 15 (+ 1) % Row 45 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}* (multiply)} \tn % Row Count 16 (+ 1) % Row 46 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}- (subtract)} \tn % Row Count 17 (+ 1) % Row 47 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}= (equal)} \tn % Row Count 18 (+ 1) % Row 48 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}{[}} \tn % Row Count 19 (+ 1) % Row 49 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}{]}} \tn % Row Count 20 (+ 1) % Row 50 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}; (semicolon)} \tn % Row Count 21 (+ 1) % Row 51 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}' (apostrophe)} \tn % Row Count 22 (+ 1) % Row 52 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}: (colon)} \tn % Row Count 23 (+ 1) % Row 53 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}/} \tn % Row Count 24 (+ 1) % Row 54 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}\textbackslash{}} \tn % Row Count 25 (+ 1) % Row 55 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Insert} \tn % Row Count 26 (+ 1) % Row 56 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Delete} \tn % Row Count 27 (+ 1) % Row 57 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Page Up} \tn % Row Count 28 (+ 1) % Row 58 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Page Down} \tn % Row Count 29 (+ 1) % Row 59 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Left Arrow} \tn % Row Count 30 (+ 1) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{8.4cm}{X} \SetRowColor{DarkBackground} \mymulticolumn{1}{x{8.4cm}}{\bf\textcolor{white}{One and Two Key Commands (cont)}} \tn % Row 60 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Right Arrow} \tn % Row Count 1 (+ 1) % Row 61 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Up Arrow} \tn % Row Count 2 (+ 1) % Row 62 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Down Arrow} \tn % Row Count 3 (+ 1) % Row 63 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Space Bar} \tn % Row Count 4 (+ 1) % Row 64 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Tab} \tn % Row Count 5 (+ 1) % Row 65 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Backspace} \tn % Row Count 6 (+ 1) % Row 66 \SetRowColor{LightBackground} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Return/Enter} \tn % Row Count 7 (+ 1) % Row 67 \SetRowColor{white} \mymulticolumn{1}{x{8.4cm}}{\{\{border=1\}\}Home} \tn % Row Count 8 (+ 1) \hhline{>{\arrayrulecolor{DarkBackground}}-} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{x{1.296 cm} x{2.016 cm} x{1.944 cm} x{1.944 cm} } \SetRowColor{DarkBackground} \mymulticolumn{4}{x{8.4cm}}{\bf\textcolor{white}{Three Key Commands}} \tn % Row 0 \SetRowColor{LightBackground} \{\{border=1\}\}{\bf{Key}} & \{\{border=1\}\}{\bf{Shift+Ctrl}} & \{\{border=1\}\}{\bf{Shift+Alt}} & \{\{border=1\}\}{\bf{Ctrl+Alt}} \tn % Row Count 3 (+ 3) % Row 1 \SetRowColor{white} \{\{border=1\}\}F1 & \{\{border=1\}\} & \{\{border=1\}\}Insert New Sheet & \{\{border=1\}\}New Macro Sheet \tn % Row Count 6 (+ 3) % Row 2 \SetRowColor{LightBackground} \{\{border=1\}\}F2 & \{\{border=1\}\} & \{\{border=1\}\}Save & \{\{border=1\}\}Open \tn % Row Count 8 (+ 2) % Row 3 \SetRowColor{white} \{\{border=1\}\}F3 & \{\{border=1\}\}Names From Labels & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 11 (+ 3) % Row 4 \SetRowColor{LightBackground} \{\{border=1\}\}F4 & \{\{border=1\}\}Find Previous & \{\{border=1\}\}Close Quickly & \{\{border=1\}\}Save \& Close \tn % Row Count 14 (+ 3) % Row 5 \SetRowColor{white} \{\{border=1\}\}F6 & \{\{border=1\}\}Previous Workbook & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 17 (+ 3) % Row 6 \SetRowColor{LightBackground} \{\{border=1\}\}F9 & \{\{border=1\}\} & \{\{border=1\}\} & \{\{border=1\}\}Recalculate Full \tn % Row Count 20 (+ 3) % Row 7 \SetRowColor{white} \{\{border=1\}\}F11 & \{\{border=1\}\} & \{\{border=1\}\}Show Script Editor & \{\{border=1\}\} \tn % Row Count 23 (+ 3) % Row 8 \SetRowColor{LightBackground} \{\{border=1\}\}F12 & \{\{border=1\}\}Print & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 26 (+ 3) % Row 9 \SetRowColor{white} \{\{border=1\}\}B & \{\{border=1\}\}Formula Arguments & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 29 (+ 3) % Row 10 \SetRowColor{LightBackground} \{\{border=1\}\}F & \{\{border=1\}\}Font Name & \{\{border=1\}\}Opens Office \seqsplit{Button/File} Tab & \{\{border=1\}\} \tn % Row Count 33 (+ 4) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{8.4cm}{x{1.296 cm} x{2.016 cm} x{1.944 cm} x{1.944 cm} } \SetRowColor{DarkBackground} \mymulticolumn{4}{x{8.4cm}}{\bf\textcolor{white}{Three Key Commands (cont)}} \tn % Row 11 \SetRowColor{LightBackground} \{\{border=1\}\}H & \{\{border=1\}\} & \{\{border=1\}\}Opens Home Ribbon & \{\{border=1\}\} \tn % Row Count 3 (+ 3) % Row 12 \SetRowColor{white} \{\{border=1\}\}L & \{\{border=1\}\}Auto Filter & \{\{border=1\}\}Opens Developer Ribbon & \{\{border=1\}\} \tn % Row Count 7 (+ 4) % Row 13 \SetRowColor{LightBackground} \{\{border=1\}\}M & \{\{border=1\}\} & \{\{border=1\}\}Opens Formula Ribbon & \{\{border=1\}\} \tn % Row Count 11 (+ 4) % Row 14 \SetRowColor{white} \{\{border=1\}\}N & \{\{border=1\}\} & \{\{border=1\}\}Opens Insert Ribbon & \{\{border=1\}\} \tn % Row Count 15 (+ 4) % Row 15 \SetRowColor{LightBackground} \{\{border=1\}\}O & \{\{border=1\}\}Select Comments & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 18 (+ 3) % Row 16 \SetRowColor{white} \{\{border=1\}\}P & \{\{border=1\}\}Font Size & \{\{border=1\}\}Opens Page Layout Window & \{\{border=1\}\} \tn % Row Count 22 (+ 4) % Row 17 \SetRowColor{LightBackground} \{\{border=1\}\}R & \{\{border=1\}\} & \{\{border=1\}\}Opens Review Ribbon & \{\{border=1\}\} \tn % Row Count 26 (+ 4) % Row 18 \SetRowColor{white} \{\{border=1\}\}W & \{\{border=1\}\} & \{\{border=1\}\}Opens View Ribbon & \{\{border=1\}\} \tn % Row Count 29 (+ 3) % Row 19 \SetRowColor{LightBackground} \{\{border=1\}\}0 & \{\{border=1\}\}Unhide Columns & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 32 (+ 3) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{8.4cm}{x{1.296 cm} x{2.016 cm} x{1.944 cm} x{1.944 cm} } \SetRowColor{DarkBackground} \mymulticolumn{4}{x{8.4cm}}{\bf\textcolor{white}{Three Key Commands (cont)}} \tn % Row 20 \SetRowColor{LightBackground} \{\{border=1\}\}1 & \{\{border=1\}\}Fixed Decimal Format & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 3 (+ 3) % Row 21 \SetRowColor{white} \{\{border=1\}\}2 & \{\{border=1\}\}Time Format & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 6 (+ 3) % Row 22 \SetRowColor{LightBackground} \{\{border=1\}\}3 & \{\{border=1\}\}Date Format & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 9 (+ 3) % Row 23 \SetRowColor{white} \{\{border=1\}\}4 & \{\{border=1\}\}Currency Format & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 12 (+ 3) % Row 24 \SetRowColor{LightBackground} \{\{border=1\}\}5 & \{\{border=1\}\}Percent Format & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 15 (+ 3) % Row 25 \SetRowColor{white} \{\{border=1\}\}6 & \{\{border=1\}\}Exponent Format & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 18 (+ 3) % Row 26 \SetRowColor{LightBackground} \{\{border=1\}\}7 & \{\{border=1\}\}Apply Border & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 21 (+ 3) % Row 27 \SetRowColor{white} \{\{border=1\}\}8 & \{\{border=1\}\}Select Region & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 24 (+ 3) % Row 28 \SetRowColor{LightBackground} \{\{border=1\}\}9 & \{\{border=1\}\}Unhide Rows & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 27 (+ 3) % Row 29 \SetRowColor{white} \{\{border=1\}\}- \seqsplit{(subtract)} & \{\{border=1\}\}Date Stamp & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 31 (+ 4) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{8.4cm}{x{1.296 cm} x{2.016 cm} x{1.944 cm} x{1.944 cm} } \SetRowColor{DarkBackground} \mymulticolumn{4}{x{8.4cm}}{\bf\textcolor{white}{Three Key Commands (cont)}} \tn % Row 30 \SetRowColor{LightBackground} \{\{border=1\}\}= \seqsplit{(equal)} & \{\{border=1\}\}Insert Dialog & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 3 (+ 3) % Row 31 \SetRowColor{white} \{\{border=1\}\}{[} & \{\{border=1\}\}Direct Precedents & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 6 (+ 3) % Row 32 \SetRowColor{LightBackground} \{\{border=1\}\}{]} & \{\{border=1\}\}All Precedents & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 9 (+ 3) % Row 33 \SetRowColor{white} \{\{border=1\}\}; \seqsplit{(semicolon)} & \{\{border=1\}\}Insert Time & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 13 (+ 4) % Row 34 \SetRowColor{LightBackground} \{\{border=1\}\}' \seqsplit{(apostrophe)} & \{\{border=1\}\}Copy Cell Value Above & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 17 (+ 4) % Row 35 \SetRowColor{white} \{\{border=1\}\}/ & \{\{border=1\}\}Select Array & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 20 (+ 3) % Row 36 \SetRowColor{LightBackground} \{\{border=1\}\}\textbackslash{} & \{\{border=1\}\}Select Cells in Other Rows & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 24 (+ 4) % Row 37 \SetRowColor{white} \{\{border=1\}\}Page Up & \{\{border=1\}\}Extend Selection One Page Up & \{\{border=1\}\}Extend Selection Page Left & \{\{border=1\}\} \tn % Row Count 28 (+ 4) % Row 38 \SetRowColor{LightBackground} \{\{border=1\}\}Page Down & \{\{border=1\}\}Extend Selection One Page Down & \{\{border=1\}\}Extend Selection Page Right & \{\{border=1\}\} \tn % Row Count 32 (+ 4) \end{tabularx} \par\addvspace{1.3em} \vfill \columnbreak \begin{tabularx}{8.4cm}{x{1.296 cm} x{2.016 cm} x{1.944 cm} x{1.944 cm} } \SetRowColor{DarkBackground} \mymulticolumn{4}{x{8.4cm}}{\bf\textcolor{white}{Three Key Commands (cont)}} \tn % Row 39 \SetRowColor{LightBackground} \{\{border=1\}\}Left Arrow & \{\{border=1\}\}Extend Selection Left to Last Cell & \{\{border=1\}\}Ungroup & \{\{border=1\}\}Move Active Cell to Previous Cell \tn % Row Count 5 (+ 5) % Row 40 \SetRowColor{white} \{\{border=1\}\}Right Arrow & \{\{border=1\}\}Extend Selection Right to Last Cell & \{\{border=1\}\}Group & \{\{border=1\}\}Move Active Cell to Next Cell \tn % Row Count 10 (+ 5) % Row 41 \SetRowColor{LightBackground} \{\{border=1\}\}Up Arrow & \{\{border=1\}\}Extend Selection Up to Last Cell & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 14 (+ 4) % Row 42 \SetRowColor{white} \{\{border=1\}\}Down Arrow & \{\{border=1\}\}Extend Selection Down to Last Cell & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 19 (+ 5) % Row 43 \SetRowColor{LightBackground} \{\{border=1\}\}Space Bar & \{\{border=1\}\}Select All & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 22 (+ 3) % Row 44 \SetRowColor{white} \{\{border=1\}\}Tab & \{\{border=1\}\}Previous Window & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 25 (+ 3) % Row 45 \SetRowColor{LightBackground} \{\{border=1\}\}Return/Enter & \{\{border=1\}\}Fill Value Into All Cells & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 29 (+ 4) % Row 46 \SetRowColor{white} \{\{border=1\}\}Home & \{\{border=1\}\}Extend Selection to First Cell in Window & \{\{border=1\}\} & \{\{border=1\}\} \tn % Row Count 34 (+ 5) \hhline{>{\arrayrulecolor{DarkBackground}}----} \end{tabularx} \par\addvspace{1.3em} \begin{tabularx}{8.4cm}{x{1.584 cm} x{2.088 cm} x{1.584 cm} x{1.944 cm} } \SetRowColor{DarkBackground} \mymulticolumn{4}{x{8.4cm}}{\bf\textcolor{white}{Four Key Commands and Formatting Commands}} \tn % Row 0 \SetRowColor{LightBackground} \{\{width=25\}\}\{\{border=1\}\}{\bf{Key}} & \{\{width=25\}\}\{\{border=1\}\}{\bf{Shift+Ctrl+Alt}} & \{\{width=25\}\}\{\{border=1\}\}{\bf{Key}} & \{\{width=25\}\}\{\{border=1\}\}{\bf{Ctrl+Enter}} \tn % Row Count 4 (+ 4) % Row 1 \SetRowColor{white} \{\{border=1\}\}F2 & \{\{border=1\}\}Print & \{\{border=1\}\}\textasciitilde{} & \{\{border=1\}\}General \tn % Row Count 6 (+ 2) % Row 2 \SetRowColor{LightBackground} \{\{border=1\}\}F4 & \{\{border=1\}\}Save \& Close & \{\{border=1\}\}\$ & \{\{border=1\}\}Currency \tn % Row Count 9 (+ 3) % Row 3 \SetRowColor{white} \{\{border=1\}\}F9 & \{\{border=1\}\}Recalculate Full Rebuild & \{\{border=1\}\}\% & \{\{border=1\}\}Percentage \tn % Row Count 13 (+ 4) % Row 4 \SetRowColor{LightBackground} \{\{border=1\}\}Tab & \{\{border=1\}\}Active Windows & \{\{border=1\}\}\textasciicircum{} & \{\{border=1\}\}Scientific \tn % Row Count 16 (+ 3) % Row 5 \SetRowColor{white} \{\{border=1\}\} & \{\{border=1\}\} & \{\{border=1\}\}\# & \{\{border=1\}\}Date \tn % Row Count 18 (+ 2) % Row 6 \SetRowColor{LightBackground} \{\{border=1\}\} & \{\{border=1\}\} & \{\{border=1\}\}@ & \{\{border=1\}\}Time \tn % Row Count 20 (+ 2) % Row 7 \SetRowColor{white} \{\{border=1\}\} & \{\{border=1\}\} & \{\{border=1\}\}! & \{\{border=1\}\}Number \tn % Row Count 22 (+ 2) \hhline{>{\arrayrulecolor{DarkBackground}}----} \end{tabularx} \par\addvspace{1.3em} % That's all folks \end{multicols*} \end{document}