Greg Harvey

Article / Updated 06-07-2023

To share Excel 2019 workbooks from your OneDrive, you follow these steps: Open the workbook file you want to share in Excel 2019 and then click the Share button at the far right of the row with the Ribbon. If you’ve not yet saved the workbook on your OneDrive, a Share dialog box appears inviting you to upload the workbook file to OneDrive. Once you have clicked the OneDrive button and the file is uploaded to the cloud, the Share dialog box changes into the Send Link dialog box (similar to the one shown in the figure) where you specify the people with whom to share the file. Begin typing the name or e-mail address of the first person with whom you want to share the workbook in the text box with the insertion point. When Excel finds a match to the person’s name in your Outlook address book or verifies the e-mail address you entered, click the button below this text box to add this recipient. (Optional) Click the Anyone with This Link Can Edit drop-down button to open the Link Settings dialog box where you can modify the people for whom the link works, deny editing privileges to those with whom you share the file, and/or set an expiration date after which the link is no longer operational before clicking the Apply button. By default, Excel 2019 creates a sharing link that enables anyone who can access the workbook file online access to the file even when they are not logged into Office 365 or OneDrive. To restrict access to only coworkers in your company who are logged into Office 365, click the People in <organization> option (where organization is the name of your company as in People in Mind Over Media, the name of my company). To restrict the file sharing to only those to whom you’ve given prior access to the workbook file or its folder on your SharePoint site, click the People with Existing Access option. To create a sharing link that only particular people can use, click the Specific People option before you click the Apply button. Then, in the Send Link dialog box, click the ellipsis (…) to the right of the Send Link title and click Manage Access on the drop-menu to open the Permissions dialog box where you select the names of the people with whom to share the workbook file before you click the back arrow button to return to the Send Link dialog box. By default, Excel allows the people with whom you share your workbooks to make editing changes to the workbook that are automatically saved on your OneDrive. If you want to restrict your recipients to reviewing the data without being able to make changes, be sure to click the Allow Editing check box to remove its check mark before you click Apply. If you wish to set an expiration date after which the sharing link is no longer operational, click the Set Expiration Date button to open the pop-up calendar where you select an expiration date by clicking it in the calendar. After selecting the expiration date, click somewhere in the dialog box to close the pop-up calendar and enter the date in the Link Settings dialog box. (Optional) Click the Add a Message text box and type any personal message that you want to incorporate as part of the e-mail with the generic invitation to share the file.By default, Excel creates a generic invitation. After adding all the recipients with whom you wish to share the workbook file in this manner, click the Send button in the Send Link pane.As soon as you click this Share button, Excel e-mails the invitation to share the workbook to each of the recipients. All the people with whom you share a workbook receive an e-mail message containing a hyperlink to the workbook on your OneDrive. When they follow this link (and sign into the site if this is required), a copy of the workbook opens on a new page in their default web browser using the Excel Online web app. If you’ve given the user permission to edit the file, the web app contains an Edit Workbook drop-down button. When the coworkers with whom you’ve shared the workbook click this button in Excel Online, they have a choice between choosing the Edit in Excel or Edit in Excel Online option from its drop-down menu. When the user chooses Edit in Excel, the workbook is downloaded and opened in his version of Excel. When the user chooses Edit in Excel Online, the browser opens the workbook in a new version of the Excel Online, containing Home, Insert, Data, Review, and View tabs, each with a more limited set of command options than Excel 2019, which you can use in making any necessary changes and which are automatically saved to workbook on the OneDrive when you close Excel Online. While sharing a workbook with the default Anyone Can Edit option, all changes made by the people with whom you’ve shared the workbook are automatically saved by the AutoSave feature. If you happen to have the workbook open in Excel 2019 on your computer with the same worksheet displayed, their editing changes automatically appear in your worksheet (in as close to real time as the speed of your Internet access provides). Likewise, all the editing changes that you make to the workbook in Excel 2019 are automatically updated in their workbooks in Excel Online. Microsoft refers to this process as co-authoring. If a questionable editing change appears in your worksheet when co-authoring with a coworker, add a comment to the cell containing the edit-in-question (Review-->New Comment) that communicates your reservations about the change they made. A small balloon then appears above the cell where you made the comment in the user’s worksheet in Excel Online. When the coworker clicks this balloon, Excel Online displays the text of your comment calling into question their edit in a Comments task pane. They can then reply to your reservations by typing their explanation for the change in the same comment in this task pane and then updating it in your workbook by clicking the Post button or they can just go ahead and make any necessary updates reflecting your reservations directly in the worksheet in Excel Online.

Article / Updated 04-25-2023

Tolkien seems to have regarded the Elves as his favorite creatures of Middle-earth, but most of his readers seem to be hobbit-lovers at heart. They find hobbits to be the most likeable and also to be the most like themselves, despite some obvious differences (for most people) in the height and furry-footedness departments. Even Tolkien referred to himself as a hobbit ("in all but size") for his love of pipe-smoking, gardens, plain and simple food, peace and quiet, his dislike of mechanized farmlands and traveling, and his fondness for wearing ornamental waistcoats on particularly dull days. Before considering what hobbits really meant to Tolkien, you need to picture them as Tolkien designed them. In the Prologue to The Lord of the Rings, Tolkien asserts that hobbits are distantly related to humans and acquaints readers with all their vital statistics. According to this Prologue, hobbit characteristics include the following: A height of between two and four feet Feet with tough, leathery soles covered in hair (they seldom wear shoes) Long skillful fingers A tendency towards chubbiness Little or no facial hair An ability to disappear swiftly and silently Excellent hearing and sharp eyesight No understanding of machinery more complicated than the watermill, forge bellows, and the hand loom A delight in wearing bright colors, particularly yellow and green A love of food and drink (especially ale), eating a mere six times a day on average A love of laughter, jests, games, and celebrations A love of peace and quiet and "good tilled" earth A particular love for the smoking of tobacco in small clay pipes For many readers, one of the more important hobbit characteristics is missing from this list — namely, their tendency to live in burrows or what Tolkien so ignobly calls a hole. In fact, Tolkien is quite clear that only extremely rich or poor hobbits live in burrows (sometimes referred to in The Lord of the Rings as smials from the Old English smygel, meaning a "burrow" or "place to crawl into"). Because Bilbo and Frodo are such major characters in The Hobbit and The Lord of the Rings, and are fairly well-to-do, you are probably more accustomed to hobbits dwelling in very well-appointed holes (none of your wet, smelly rabbit holes, mind you). The more middle-class hobbits, Tolkien assures you, dwell above ground in houses of wood, brick, or stone. Hobbits are deeply contented with their way of life. Understanding the level of this contentment is important to comprehending their central role in The Lord of the Rings and The Hobbit. Tolkien therefore spends a good deal of time introducing the reader to the way hobbits party and hang out together, thus ensuring that his readers understand the depth of this contentment. A great part of the overall contentment with the hobbit way of life comes from their deep love of the Shire (from Old English scir meaning a "district"). The Shire is the region where most hobbits live, in the northwest section of the land of Eriador. Tolkien, like many English authors before him, is in love with his own "shire" (the Midlands in his case) and therefore naturally fosters in his hobbit characters a parallel love for their homeland. In the tradition of English villagers at the turn of the nineteenth century, the hobbits of the Shire are very distrustful of any kind of stranger. They think it quite "queer" when they run into hobbits such as Bilbo and Frodo who go off on foreign adventures. Because everything any hobbit could desire is found right in the Shire, why would any hobbit in his right mind want to go off to some strange, far-off land in search of adventure, of all things! They often say that this isn't natural and trouble will come of it. And it often does. So hobbits are Tolkien's "Everyman" in Middle-earth — creatures who just want to mind their own business and live a simple life. But the hobbits' simple life, just the like the one that Tolkien knew as a boy in the village of Sarehole (a hamlet just outside Birmingham), is being threatened by the outside world. Just as Tolkien saw the urban sprawl from Birmingham threaten the isolation and idyllic rural existence of Sarehole, the Shire in the Third Age faces its own menace from without that threatens to end its isolation from the rest of Middle-earth and endanger the hobbits' very way of life. Hobbits and their homespun wisdom Among the many delightful aspects of hobbits is their great homespun wisdom. Tolkien puts a number of pithy sayings, proverbs, and aphorisms into the mouths of the hobbits of the Shire. On the surface, the wisdom of these sayings appears commonsensical, but becomes a bit more complex when examined further. In Middle-earth, hobbits could write the equivalent of Ben Franklin's Poor Richard's Almanac —they achieve contentment by living their lives according to truisms. One of the first of these sayings comes from the Gaffer, Sam's dad. At one point, the Gaffer warns his son about queer folk such as Bilbo Baggins by telling him not to get mixed up in the affairs of "your betters" or "you'll land in trouble too big for you." When the hobbit fellowship of Frodo, Sam, Merry, and Pippin are making their way to the Bucklebury Ferry, Frodo suggests cutting across country to save time and avoid the roads (and the Black Riders who are following them). Pippin responds, "Short cuts make long delays." A couple of favorite aphorisms come from the incident in which Frodo finally gets Gandalf's letter at the inn of the Prancing Pony in Bree, warning him to make sure that he's dealing with the "real" Strider. Frodo tells Strider that if he (Strider) were a spy of the Enemy, he would somehow "seem fairer and feel fouler." Then, after Strider wryly observes that his looks are against him, Pippin quotes the old saying of the Shire, "handsome is as handsome does" — words of wisdom that many a mother tries to pass on to her daughters. As you can see, these commonsensical hobbit sayings are cautions when making judgments about the truth of a situation. They are forewarnings of the troubles that come your way when you can't effectively make these determinations. This makes them typical of the kind "folk" wisdom and truisms that that abound not only in faraway legends but also in today's small communities all around the world. Hobbit-sized heroes Despite their short stature and relatively conservative nature, at least when it comes to traveling and going on adventures, hobbits are the heroes of The Hobbit and The Lord of the Rings. In the case of The Hobbit, Bilbo Baggins saves the day for the Dwarves of the Lonely Mountain, even though it is a Man, Bard the Bowman, who slays Smaug the dragon, and even though it takes a host of Men, Elves, Dwarves, eagles, plus Gandalf to defeat the army of goblins and wolves. In the case of The Lord of the Rings, it's the hobbits Frodo, Sam, Pippin, Merry, and yes, even Sméagol/Gollum, who save Middle-earth from the domination of Sauron. On the one hand, you may find it strange that Tolkien calls upon the "wee" folk of his fantasy world to carry the day. On the other hand, if you consider the hobbits' diminutive stature as a sign not of a lack of courage or steadfastness, but rather as a lack of towering ambition and desire, their heroic role makes perfect sense. In The Lord of the Rings, the Men, Elves, Dwarves, and wizards in the story, for all their might, are not able to handle the One Ring. Only Bilbo, Frodo, Sam, and Gollum are able to bear it, each with differing amounts of harm to their personalities. All those "greater" in stature than the hobbits, including the Dwarves because of their greater stoutness, are hampered by their high aspirations and the great purposes to which they would put the One Ring. To be sure, those purposes are noble ones, such as defending their people and defeating the Enemy. But most hobbits lack any overarching goals (other than a pint of beer and a good meal) that the One Ring could amplify and distort and in turn use to control them. The hobbit who suffers the most in bearing the Ring is Frodo, because he carries the ambition of destroying the Ring in the fires of Mount Doom — a noble goal but one that the Ring itself naturally resists. The hobbits' way of life also suggests the "common person" who does his or her duty without any greater goal than a job well done and seeing the matter through to its conclusion — the ideal of any good infantryman, as Tolkien's experience on the front in World War I confirmed. By contrast, the high and the mighty seldom, if ever, do anything for its own sake. They are always working for a "greater" goal that inevitably colors the endeavor and that often can work against the very thing they want so badly to accomplish. Viewed in this light, Tolkien's selection of hobbits as the true heroes of The Lord of the Rings and The Hobbit marks these works as very contemporary in outlook. For it seems that in contemporary history — the modern democratic age — the common man is the hero. This was especially true in the two World Wars (Tolkien fought in the first one, and his son Christopher fought in the second). In Tolkien's opinion, it wasn't the lieutenants, colonels, and commanders who were the true heroes of the war, but rather the common soldier — especially the foot soldier, the nameless infantryman.

Step by Step / Updated 09-16-2022

You can add text comments to particular cells in an Excel 2013 worksheet. Comments act kind of like electronic pop-up versions of sticky notes. For example, you can add a comment to yourself to verify a particular figure before printing the worksheet or to remind yourself that a particular value is only an estimate. In addition to using notes to remind yourself of something you’ve done or that remains to be done, you can also use a comment to mark your current place in a large worksheet. You can then use the comment’s location to quickly find your starting place the next time you work with that worksheet. To add a comment to a cell, click on the cell to which you want to add the comment and follow these steps:

Article / Updated 08-01-2022

Excel’s AutoFilter feature makes filtering out unwanted data in a data list as easy as clicking the AutoFilter button on the column on which you want to filter the data and then choosing the appropriate filtering criteria from that column’s drop-down menu. If you open a worksheet with a data list and you don’t find Excel’s AutoFilter buttons attached to each of the field names at the top of the list, you can display them simply by positioning the cell pointer in one of the cells with the field names and then clicking the Filter command button on the Ribbon’s Data tab or pressing Ctrl+Shift+L or Alt+AT. The filter options on a column’s AutoFilter drop-down menu depend on the type of entries in the field. On the drop-down menu in a column that contains only date entries, the menu contains a Date Filters option to which a submenu of the actual filters is attached. On the drop-down menu in a column that contains only numeric entries (besides dates) or a mixture of dates with other types of numeric entries, the menu contains a Number Filters option. On the drop-down menu in a column that contains only text entries or a mixture of text, date, and other numeric entries, the menu contains a Text Filters option. Doing basic filtering in Excel 2019 by selecting specific field entries In addition to the Date Filters, Text Filters, or Number Filters options (depending on the type of field), the AutoFilter drop-down menu for each field in the data list contains a list box with a complete listing of all entries made in that column, each with its own check box. At the most basic level, you can filter the data list by clearing the check box for all the entries whose records you don’t want to see in the list. This kind of basic filtering works best in fields such as City, State, or Country, which contain many duplicates, so you can see a subset of the data list that contains only the cities, states, or countries you want to work with at the time. The easiest way to perform this basic type of filtering on a field is to first deselect the check box in front of the (Select All) option at the top of the field’s list box to clear the check boxes, and then select each of the check boxes containing the entries for the records you do want displayed in the filtered data list. After you finish selecting the check boxes for all the entries you want to keep, you click OK to close the AutoFilter drop-down menu. Excel then hides rows in the data list for all records except for those that contain the entries you just selected. The program also lets you know which field or fields have been used in the filtering operation by adding a cone filter icon to the column’s AutoFilter button. To restore all the records to the data list, you can remove the filtering by clicking the Clear command button in the Sort & Filter group of the Data tab of the Ribbon or by pressing Alt+AC. When doing this basic kind of list filtering, you can select specific entries from more than one field in this list. The following image illustrates this kind of situation. Here, I want only the employees in the company who work in the Engineering and Information Services departments in the Chicago and Seattle offices. To do this, I selected only the Engineering and Information Services entries in the list box on the Dept field’s AutoFilter drop-down menu and only the Chicago and Seattle entries in the list box on the Location field’s AutoFilter drop-down menu. As you can see above, after filtering the Employee data list so that only the records for employees in either the Engineering or Information Services department in either the Chicago or Seattle office locations are listed, Excel adds the cone filter icon to the AutoFilter buttons on both the Dept and Location fields in the top row, indicating that the list is filtered using criteria involving both fields. Keep in mind that after filtering the data list in this manner, you can then copy remaining records that make up the desired subset of the data list to a new area in the same worksheet or to a new sheet in the workbook. You can then sort the data (by adding AutoFilter buttons with the Filter command button on the Data tab), chart the data, analyze the data, or summarize the data in an Excel pivot table. Using the Text Filters options in Excel 2019 The AutoFilter drop-down menu for a field that contains only text or a combination of text, date, and numeric entries contains a Text Filters option that when you click or highlight displays its submenu containing the following options: Equals: Opens the Custom AutoFilter dialog box with the Equals operator selected in the first condition. Does Not Equal: Opens the Custom AutoFilter dialog box with the Does Not Equal operator selected in the first condition. Begins With: Opens the Custom AutoFilter dialog box with the Begins With operator selected in the first condition. Ends With: Opens the Custom AutoFilter dialog box with the Ends With operator selected in the first condition. Contains: Opens the Custom AutoFilter dialog box with the Contains operator selected in the first condition. Does Not Contain: Opens the Custom AutoFilter dialog box with the Does Not Contain operator selected in the first condition. Custom Filter: Opens the Custom AutoFilter dialog box where you can select your own criteria for applying more complex AND or conditions. Using the Date Filters options in Excel 2019 The AutoFilter drop-down menu for a field that contains only date entries contains a Date Filters option that when you click or highlight displays its submenu containing the following options: Equals: Opens the Custom AutoFilter dialog box with the Equals operator selected in the first condition. Before: Opens the Custom AutoFilter dialog box with the Is Before operator selected in the first condition. After: Opens the Custom AutoFilter dialog box with the Is After operator selected in the first condition. Between: Opens the Custom AutoFilter dialog box with the Is After or Equal To operator selected in the first condition and the Is Before or Equal To operator selected in the second AND condition. Tomorrow: Filters the data list so that only records with tomorrow’s date in this field are displayed in the worksheet. Today: Filters the data list so that only records with the current date in this field are displayed in the worksheet. Yesterday: Filters the data list so that only records with yesterday’s date in this field are displayed in the worksheet. Next Week: Filters the data list so that only records with date entries in the week ahead in this field are displayed in the worksheet. This Week: Filters the data list so that only records with date entries in the current week in this field are displayed in the worksheet. Last Week: Filters the data list so that only records with date entries in the previous week in this field are displayed in the worksheet. Next Month: Filters the data list so that only records with date entries in the month ahead in this field are displayed in the worksheet. This Month: Filters the data list so that only records with date entries in the current month in this field are displayed in the worksheet. Last Month: Filters the data list so that only records with date entries in the previous month in this field are displayed in the worksheet. Next Quarter: Filters the data list so that only records with date entries in the three-month quarterly period ahead in this field are displayed in the worksheet. This Quarter: Filters the data list so that only records with date entries in the current three-month quarterly period in this field are displayed in the worksheet. Last Quarter: Filters the data list so that only records with date entries in the previous three-month quarterly period in this field are displayed in the worksheet. Next Year: Filters the data list so that only records with date entries in the calendar year ahead in this field are displayed in the worksheet. This Year: Filters the data list so that only records with date entries in the current calendar year in this field are displayed in the worksheet. Last Year: Filters the data list so that only records with date entries in the previous calendar year in this field are displayed in the worksheet. Year to Date: Filters the data list so that only records with date entries in the current year up to the current date in this field are displayed in the worksheet. All Dates in the Period: Filters the data list so that only records with date entries in the quarter (Quarter 1 through Quarter 4) or month (January through December) that you choose from its submenu are displayed in the worksheet. Custom Filter: Opens the Custom AutoFilter dialog box where you can select your own criteria for more complex AND or conditions. When selecting dates for conditions using the Equals, Is Before, Is After, Is Before or Equal To, or Is After or Equal To operator in the Custom AutoFilter dialog box, you can select the date by clicking the Date Picker button (the one with the calendar icon) and then clicking the specific date on the drop-down date palette. When you open the date palette, it shows the current month and the current date selected. To select a date in an earlier month, click the Previous button (the one with the triangle pointing left) until its month is displayed in the palette. To select a date in a later month, click the Next button (the one with the triangle pointing right) until its month is displayed in the palette. Using the Number Filters options in Excel 2019 The AutoFilter drop-down menu for a field that contains only number entries besides dates or a combination of dates and other numeric entries contains a Number Filters option that when you click or highlight it displays its submenu containing the following options: Equals: Opens the Custom AutoFilter dialog box with the Equals operator selected in the first condition. Does Not Equal: Opens the Custom AutoFilter dialog box with the Does Not Equal operator selected in the first condition. Greater Than: Opens the Custom AutoFilter dialog box with the Is Greater Than operator selected in the first condition. Greater Than or Equal To: Opens the Custom AutoFilter dialog box with the Is Greater Than or Equal To operator selected in the first condition. Less Than: Opens the Custom AutoFilter dialog box with the Is Less Than operator selected in the first condition. Less Than or Equal To: Opens the Custom AutoFilter dialog box with the Is Less Than or Equal to operator selected in the first condition. Between: Opens the Custom AutoFilter dialog box with the Is Greater Than or Equal To operator selected in the first condition and the Is Less Than or Equal To operator selected in the second AND condition. Top 10: Opens the Top 10 AutoFilter dialog box so that you can filter the list to just the ten or so top or bottom values or percentages in the field. Above Average: Filters the data list to display only records where the values in the field are greater than the average of the values in this field. Below Average: Filters the data list to display only records where the values in the field are less than the average of the values in this field. Custom Filter: Opens the Custom AutoFilter dialog box where you can select your own criteria for more complex AND or conditions. Making it to the Top Ten! The Top Ten option on the Number Filters option’s submenu enables you to filter out all records except those whose entries in that field are at the top or bottom of the list by a certain number (10 by default) or in a certain top or bottom percent (10 by default). Of course, you can only use the Top Ten item in numerical fields and date fields; this kind of filtering doesn’t make any sense when you’re dealing with entries in a text field. When you click the Top Ten option on the Number Filters option’s submenu, Excel opens the Top 10 AutoFilter dialog box where you can specify your filtering criteria. By default, the Top 10 AutoFilter dialog box is set to filter out all records except those whose entries are among the top ten items in the field by selecting Top in the drop-down list box on the left, 10 in the middle combo box, and Items in the drop-down list box on the right. If you want to use these default criteria, you simply click OK in the Top 10 AutoFilter dialog box. The image below shows you the sample employee data list after using the Top 10 Items AutoFilter to display only the records with the top ten salaries in the data list. You can also change the filtering criteria in the Top 10 AutoFilter dialog box before you filter the data. You can choose between Top and Bottom in the leftmost drop-down list box and between Items and Percent in the rightmost one. You can also change the number in the middle combo box by clicking it and entering a new value or using the spinner buttons to select one. Filtering an Excel data list on a field’s font and fill colors or cell icons Just as you can sort a data list using the font or fill color or cell icons that you’ve assigned with the Conditional Formatting feature to values in the field that are within or outside of certain parameters, you can also filter the list. To filter a data list on a font color, fill color, or cell icon used in a field, you click its AutoFilter button and then select the Filter by Color option from the drop-down menu. Excel then displays a submenu from which you choose the font color, fill color, or cell icon to use in the sort: To filter the data list so that only the records with a particular font color in the selected field — assigned with the Conditional Formatting Highlight Cell Rules or Top/Bottom Rules options — appear in the list, click its color swatch in the Filter by Font Color submenu. To filter the data list so that only the records with a particular fill color in the selected field — assigned with the Conditional Formatting Highlight Cell Rules, Top/Bottom Rules, Data Bars, or Color Scales options — appear in the list, click its color swatch in the Filter by Font Color submenu. To filter the data list so that only the records with a particular cell icon in the selected field — assigned with the Conditional Formatting Icon Sets options — appear in the list, click the icon in the Filter by Cell Icon submenu.

Cheat Sheet / Updated 04-27-2022

J.R.R. Tolkien made his literary mark on 20th century readers and contemporary audiences with the rich characters, language, geography, and history of his fascinating world of Middle-earth. Explore the author's own origins, check out his list of notable works, and meet a cast of beings that abound in masterful fantasy storytelling.

Cheat Sheet / Updated 04-20-2022

As an integral part of the Ribbon interface used by the major applications included in Microsoft Office 2010, Excel gives you access to hot keys that can help you select program commands more quickly. As soon as you press the Alt key, Excel displays the mnemonic letter choices on the various tabs and command buttons on the Ribbon. Then, simply press the mnemonic (or not-so-mnemonic) letters to perform a particular task.

Cheat Sheet / Updated 04-18-2022

At first glance, you might have trouble making sense of the many menus, tabs, columns, and rows of the Excel 2010 user interface. This Cheat Sheet will help you navigate your way by showing you keystrokes for moving the cell cursor to a new cell, simple rules of data-entry etiquette, common causes of some formula error values, and a quick list of the best Excel 2010 features.

Cheat Sheet / Updated 03-28-2022

In Microsoft Excel 2019, you can use the keyboard to select cells and access hot key sequences that can greatly speed up the process of selecting program commands. Excel 2019 also makes it easy to set regional dates, share workbooks saved on your OneDrive, and add SmartArt graphics to your worksheets. In Excel 2019, you also can sort multiple fields in a data list, create a new pivot table, or add a description to a user-defined function. This Cheat Sheet is a handy reference to these Excel functions.

Cheat Sheet / Updated 03-21-2022

At first glance, you might have trouble making sense of the many menus, tabs, columns, and rows of the Excel 2016 user interface. However, you can figure out what you're doing by using keystrokes to move the cell cursor to a new cell, following simple rules of data-entry etiquette, discovering common causes of some formula error values, and a reading a quick list of the best Excel 2016 features.

Cheat Sheet / Updated 03-14-2022

At first glance, you might have a little trouble making sense of the Excel 2019 worksheet window with its many components. Just keep in mind that when you’re unsure of the purpose of a particular command button displayed in the Excel worksheet window, all you have to do is to position the mouse pointer on that button’s icon to have Excel display the button’s name, its shortcut keys (if it has them), and, often, a short description of the button’s function.