Recently, I was asked how to change Excel’s default date from the format 3/10/2019 to Sunday, March 10, 2019. There are a few number formatting options that can accomplish this. In Excel, the Number Format options allow you create custom
Fitting Worksheet Content on a Page
There are some instances where you want to fit the contents of a workbook onto a single page (or limit how many pages wide a workbook prints, or pages tall a workbook prints). Rather than adjusting column width to get
Sampling Colors in Office
If you’re like me and you’re developing something such as a newsletter or sign, you want the branding colors based on a logo to match to perfection. There’s a nifty feature built into Microsoft Publisher that can be used to
Showing and Hiding Data in Excel
Excel has a feature that allows you to hide cells for printing or display purposes, and also allows you to un-hide them. To hide rows or columns in Excel: Highlight the row or column header(s) for those row(s) or column(s)
Moving Cells in Excel
Have you ever wanted to move rows or columns of cells in Excel, but struggled to keep the formulas in place when changing the layout of your workbook? Here’s how to move cells in Excel, while keeping formulas intact: Highlight
Apostrophe Shortcut in Excel
When using Excel, by default, cell contents that look like a number are treated as a number. At times, this can be inconvenient as Excel also truncates leading zeroes on text that is a number, but shouldn’t be calculated on
Inserting Rows and Columns in Excel
Inserting a Column in Excel To insert a column in Excel, select the column where you want the new column to appear. If you want to insert multiple columns next to each other, click and drag across the number of
Dates and Times with Excel
Excel offers numerous shortcuts and functions to make life easier when working with dates and times. Here are some examples: Current Date and Time Logging daily information for historical purposes can be as simple as a couple keystrokes. By using
The Fill Handle
Microsoft Excel has a handy feature to reduce repetitious patterned data entry, known as the Fill Handle. The Fill Handle can be used to copy formulas, cell contents, and continue patterns (such as dates and numbers) in a series. The
Adding Text to Shapes
There are two ways to place text in a Shape in a Microsoft Office program. One way to place text in a Shape is to create a textbox, and move the textbox over the Shape. The downside of this method,