866 tools and guides in Utilities. Pick one and use it right away.
A step-by-step guide to auto-numbering a column in a Word table โ from selecting the column to clicking numbering, choosing a style, and watching new rows update automatically.
Utilities โA step-by-step guide to autofilling consecutive dates in Excel โ from entering the first date to dragging the fill handle, checking the autofill options, and skipping weekends.
Utilities โA step-by-step guide to naming cells and ranges in Excel โ from selecting a range to using the Name Box, typing a name, and referencing it directly inside formulas.
Utilities โA step-by-step guide to inserting sparklines in Excel โ from selecting a cell to inserting a sparkline, setting the data range, and customizing its style.
Utilities โA step-by-step guide to Excel Goal Seek โ from preparing a formula cell to opening What-If Analysis, setting a target value, and reading the result.
Utilities โA step-by-step guide to printing a Word document as a folded booklet โ from opening the print menu to choosing Book Fold in Page Setup and enabling double-sided printing.
Utilities โLearn how to pull out part of a text string with LEFT, RIGHT, and MID, and pair them with LEN for flexible extraction.
Utilities โReplace plain dot or square bullets with a logo or custom icon image, from selecting your list to defining a new picture bullet.
Utilities โEnter two dates, subtract them directly, use DATEDIF for year/month/day breakdowns, and calculate time differences too.
Utilities โFrom the basic undo shortcut to repeated undos, the Undo History list, and redoing, here is how multi-step undo works in Word.
Utilities โFrom the & operator to the CONCAT function, adding separators, and TEXTJOIN, here is how to merge text across cells in Excel.
Utilities โWhat an array formula is, a SUMPRODUCT-style example, entering with Ctrl+Shift+Enter, and how modern Excel handles it automatically.
Utilities โInsert a section break, double-click into the new header, unlink it from the previous section, and type a new one โ a complete guide.
Utilities โInsert an image, adjust its size and properties, set it to move and size with cells, and drag it to fit โ a complete guide.
Utilities โSelect your line, open the Paragraph dialog, set a tab stop position, and choose a leader style โ a complete guide to tab leaders in Word.
Utilities โIdentify the error, wrap the formula in IFERROR, see a VLOOKUP example, and decide what value to display instead โ a full guide.
Utilities โSpot hidden spaces, use TRIM, use CLEAN, and combine both functions โ a complete guide to cleaning up messy text in Excel.
Utilities โShow formatting marks, select the entire page content, delete it, and remove the leftover page break โ here's how to delete a specific page in Word.
Utilities โSelect your cells, open Format Cells, choose Custom, and enter a format code โ here's how to build a custom number format in Excel for thousand separators and currency symbols.
Utilities โOpen the print menu, access printer properties, choose grayscale, and apply the setting โ here's how to switch between color and black-and-white printing in Word.
Utilities โClick your chart, open the Chart Design tab, choose Change Chart Type, and pick a new type โ here's how to switch an existing chart to a different chart type in Excel.
Utilities โOpen the Page Layout tab, find the Gridlines group, check the Print box, and preview the result โ here's how to include gridlines when printing in Excel.
Utilities โSee why regular row numbers break under filtering, then enter a SUBTOTAL formula, fill it down, and apply a filter โ here's how to keep sequential numbering on filtered data in Excel.
Utilities โCompose a new email, click the Google Drive icon, select your file, and set the sharing permission โ here's how to send large file attachments in Gmail using a Drive link.
Utilities โSelect a cell, right-click and choose New Note, type your text, and hover to view it โ here's how to add a note to a cell in Excel.
Utilities โDouble-click the sheet tab, type a new name, press Enter to confirm, or use the right-click menu โ here's how to rename a worksheet in Excel.
Utilities โSelect your text, find the paragraph alignment options, choose Distributed, and check the result โ here's how to use distributed (justify-evenly) alignment in Word.
Utilities โSelect your range, open Format Cells, go to the Alignment tab, and choose Center Across Selection โ here's how to center text visually in Excel without merging cells.
Utilities โSelect a data range, click the Quick Analysis icon, pick a category, and preview the result โ here is how to use Excel's Quick Analysis tool.
Utilities โPrepare delimited text, select it, use Insert > Table > Convert Text to Table, and confirm the separator โ here is how to turn a plain-text list into a table in Word.
Utilities โOpen File > Options, go to Proofing, open AutoCorrect Options, and uncheck "Internet and network paths with hyperlinks" โ here is how to stop Word from auto-linking web and email addresses.
Utilities โSort by a key column, select the data range, open Data > Subtotal, and set the grouping and calculation fields โ here is how to use Excel's Subtotal feature.
Utilities โSign in with your Microsoft account, open Save As, choose OneDrive, and set it as your default location โ here is how to make cloud storage your default save spot in Word.
Utilities โSelect your data, open Data > Sort, choose Custom List from the Order dropdown, and create or select a list โ here is how to sort by a custom order in Excel.
Utilities โSelect a cell range, open the Cell Styles gallery on the Home tab, pick a style, or build your own โ here is how to apply built-in and custom cell styles in Excel.
Utilities โClick the search options icon, set your filter conditions, click Create Filter, and choose an action โ here is how to automatically sort incoming Gmail messages.
Utilities โOpen Save As, choose a location, change the file type to Word 97-2003 Document, and save โ here is how to save a Word file so people using an older version can open it.
Utilities โClick and hold a sheet tab, drag it to the position you want, and release โ or use the right-click Move or Copy menu โ here is how to reorder sheet tabs in Excel.
Utilities โFormat a heading the way you want, right-click its style in the gallery, choose Update to Match Selection, and confirm it applies throughout โ here is how to customize heading styles in Word.
Utilities โFrom selecting validated cells to opening Data Validation, switching to the Error Alert tab, and writing a custom title and message, here is how to customize Excel error messages.
Utilities โFrom preparing the sheets to be combined to selecting a destination cell, opening the Consolidate menu, and choosing a function and ranges, here is how to consolidate data across multiple Excel sheets.
Utilities โFrom opening the Design tab to clicking Page Color, selecting Fill Effects, and choosing your gradient colors, here is how to add a gradient background to a Word document.
Utilities โFrom opening your document to opening the View tab, clicking Split, and scrolling each pane independently, here is how to split a Word window into two panes.
Utilities โFrom selecting a range to opening Conditional Formatting, choosing an icon set, and adjusting the thresholds, here is how to use icon sets (traffic-light style indicators) in Excel.
Utilities โFrom opening Gmail settings to finding the Signature section, clicking the image icon, and uploading and resizing your logo, here is how to add an image to a Gmail signature.
Utilities โFrom opening File > Options to the Advanced menu, the AutoComplete checkbox, and unchecking and confirming, here is how to turn off AutoComplete for cell values in Excel.
Utilities โFrom selecting a table or picture to opening the References tab, clicking Insert Caption, and choosing a label and position, here is how to insert automatic numbered captions in Word.
Utilities โFrom opening the Page Layout tab to finding the Scale to Fit group, setting it to 1 page, and checking Print Preview, here is how to fit an Excel printout onto one page.
Utilities โFrom understanding the cause to undoing immediately, locating the affected formula, and rewriting it, here is how to fix a #REF! error in Excel.
Utilities โFrom opening the Design tab to clicking Page Borders, choosing a border style, and applying an art border, here is how to add a page border in a Word document.
Utilities โUnderstand the yellow security warning bar, enable content safely, adjust macro settings in the Trust Center, and register trusted locations so macros run smoothly.
Utilities โPrepare your macro, insert a form control button from the Developer tab, draw it on the sheet, and assign the macro so anyone can run it with one click.
Utilities โSelect the cells that should stay editable, unlock them in Format Cells, protect the sheet from the Review tab, and set a password so only those cells can be changed.
Utilities โOpen Gmail settings, find the Stars section, drag the icons you want into use, and click through them in your inbox to switch colors and shapes.
Utilities โOpen the Design tab, click Watermark, choose Custom Watermark, and type your own text with a font and color of your choice, instead of using a built-in phrase.
Utilities โFind the Name Box next to the formula bar, click it, type a cell address, and press Enter to jump straight there without scrolling.
Utilities โOpen the Page Layout tab, click Background, choose an image file, and see it tiled across the entire sheet for a decorative on-screen look.
Utilities โOpen the View tab, click Page Break Preview, drag the blue lines to adjust where pages split, and return to Normal view when you are done.
Utilities โOpen the Page Layout tab, click Margins, choose Custom Margins, and enter your own top, bottom, left, and right values for precise control.
Utilities โType the first result by hand, start a similar pattern in the next row, accept the automatic suggestion, or trigger it manually from the Data tab.
Utilities โ