Excel
Microsoft Excel: How to freeze Rows & Columns
Microsoft Excel: How to freeze Rows & Columns Freeze the Top Row or First Column Click on the View tab on the Excel Ribbon. Click the drop-down for Freeze Panes. Click Freeze Top Row – allows scrolling down many rows and still shows the top row. OR ...
Microsoft Excel: Keyboard Shortcuts
Microsoft Excel: Keyboard Shortcuts Do you find using a mouse to manage your Excel worksheet a bit of an annoyance? Would you rather command it from your keyboard? Then you need to learn about keyboard shortcuts. There are quite a few commands and ...
Microsoft Excel: Transpose (rotate) Data from Rows to Columns or Inversely
Microsoft Excel: Transpose (rotate) Data from Rows to Columns or Inversely If you have a worksheet with data in columns that you need to rearrange into rows; use the Transpose feature. With it, you can quickly switch data from columns to rows, or ...
Microsoft Excel: Concatenation (Concat)
Microsoft Excel: Concatenation (Concat) Concatenation – What is it? The CONCAT function is one of Excel’s text functions. It is used to join two or more columns of text from multiple ranges and/or strings, but it doesn’t provide delimiter or ...
Microsoft Excel: Text to Columns
Microsoft Excel: Text to Columns Data imported from other spreadsheets or databases is already separated into fields, using something called a field delimiter: a comma, tab, space, or custom character – to separate one field from another. These ...
Microsoft Excel: Header and Footer – Insert, Edit and Remove
Microsoft Excel: Header and Footer – Insert, Edit and Remove To make your printed Excel documents look more stylish and professional, you can include a header or footer on each page of your worksheet. Generally, headers and footers contain basic ...
Microsoft Excel: How to print row and column headers on every page
Microsoft Excel: How to print row and column headers on every page In printing spreadsheets; the top row is printed only on the first page. Here is how to repeat the header row on your print jobs. Repeat Excel header rows on every page Your Excel ...
Microsoft Excel: Turn table headers on or off
Microsoft Excel: Turn table headers on or off When you create an Excel table, a table Header Row is automatically added as the first row of the table, but you have to option to turn it off or on. When you first create a table, you have the option of ...
Microsoft Excel: How to add an always visible Top Row in a table
Microsoft Excel: How to add an always visible Top Row in a table To add an always-visible title, you can place it in the top row of your spreadsheet. 1. First we are going to add a new top row. Right-click cell A1 (the first cell at the top left of ...
Microsoft Excel: How to insert page numbers
Microsoft Excel: How to insert page numbers This article explains page numbering in Excel. Find out how to insert page numbers in Excel if your workbook contains one or multiple worksheets, how to set a custom number for the starting sheet or delete ...
Microsoft Excel: How to Add a Watermark to a Worksheet
Microsoft Excel: How to Add a Watermark to a Worksheet Do you still think that you can’t add a watermark to your Excel worksheet? I have to say that you are all abroad. You can mimic watermarks in Excel 2019, 2016, and 2013 using the HEADER & FOOTER ...
Microsoft Excel: How to make pivot charts
Microsoft Excel: How to make pivot charts The tutorial shows how to quickly create, filter and customize pivot charts in Excel, so you can make the most of your data. If you’ve ever felt overwhelmed by a large and cluttered spreadsheet, you’re not ...
Microsoft Excel: How to select alternate columns
Microsoft Excel: How to select alternate columns This article will guide you step-by-step through the process of selecting specific columns in Excel, such as every other or every nth column. Microsoft Excel, the go-to spreadsheet software for data ...
Microsoft Excel: How to select every other row or every nth row
Microsoft Excel: How to select every other row or every nth row In this article, we will explore different methods to select every other or every nth row in Excel, whether you are working with small datasets or larger ones. If you’ve ever found ...
Microsoft Excel: How to select rows and columns
Microsoft Excel: How to select rows and columns In this article, we will guide you through various methods to select rows and columns in Excel, including some helpful shortcuts. Efficiency is the name of the game when it comes to Excel. Selecting ...
Microsoft Excel: How to make Drop-down lists
Microsoft Excel: How to make Drop-down lists In Excel 365, they’ve added the ability to search within data validation lists, which is a huge time-saver when working with large sets of data. However, even with this new option, out-of-the-box Excel ...
Microsoft Excel: Add a combo box to a worksheet
Microsoft Excel: Add a combo box to a worksheet When you want to display a list of values that users can choose from, you can add a combo box to your worksheet. Note: If your Excel Ribbon does not have the Developer tab do the following; Click File > ...
Microsoft Excel: Add a combo box to a worksheet
Microsoft Excel: Add a combo box to a worksheet When you want to display a list of values that users can choose from, you can add a combo box to your worksheet. Note: If your Excel Ribbon does not have the Developer tab do the following; Click File > ...