Home > Excel Topics > Structure

Excel Structure Topics on Contextures

Tips and templates, for Excel workbooks, worksheets, names, comments, and objects. Troubleshoot errors, add comments, set up named ranges, freeze panes, and more.

open the Page Setup dialog box

Structure - Workbooks

These tutorials have Excel workbook tips, techniques, and macros.

Names -- How to create Excel names for 1 or more cells. Make dynamic named ranges that change size automatically. Step-by-step videos, written steps, Excel file. Details on the Named Ranges page.

	Columns -- Excel column headings show numbers (1, 2, 3), instead of column letters (A, B, C). See why that happens, how to show letters again. Details on the Change Column Numbers to Letters page.
	Workbook Tips -- Easy trick to copy Excel workbooks, copy sheet to different file, time-saving navigation tips, stop personal information warning, handy spacer tabs. Details on the Excel Workbook Tips page.
	Ribbon -- Quickly scan Ribbon tabs to find commands. Make Ribbon smaller of full size. Move Ribbon command groups to different location for efficient layout. Details on the Excel Ribbon Tips page.

	Status Bar -- Use Status Bar info to troubleshoot problems, and get key information. For macros, show custom messages with macro progress updates. Details on the Status Bar Tips page.
	QAT -- How to customize the Excel Quick Access Toolbar (QAT). Add macros and favorite commands, remove unused commands. Details on the Quick Access Toolbar page.

	Preview Picture -- Show preview picture for Excel files in Office 365, in Windows Explorer. See custom thumbnails on desktop. Details on the Preview Picture page.
	Macro - Worksheets -- Create worksheets automatically when file opens at start of month. Click button to create monthly workbooks and worksheets for entire year. Details on the Create Workbooks Automatically page.
	Custom Views -- Use Custom Views to quickly print Excel reports, with different layouts and print setting, using no macros. For workbooks with no named tables. Details on the Custom Views page.

Structure - Worksheets

These tutorials have Excel worksheet tips, techniques, and macros.

Sheet Tips -- How to quickly copy and rename Excel worksheets, stop row autofit, center headings, stop footer scaling, set scroll area and more. Videos, files, written steps. Details on the Worksheet Tips and Macros page.

	Insert -- Insert multiple rows or cells quickly, using Excel shortcuts or commands. Insert one or more rows, delete rows, insert or delete cells Sheet cells or named table. Details on the Quickly Insert Rows Cells-Excel Worksheet Shortcut page.
	Blank Cells -- How to fix Excel blank cells that are not really blank. Troubleshoot not blank cells. Short videos, Excel file. Details on the Excel Blank Cells Not Blank-Troubleshoot-Fix page.
	Freeze Panes -- How to freeze Excel rows and columns, to lock in place. Which option to use. Fix problems hidden rows columns after freezing. Ctrl Home shortcut freeze panes. Details on the How to Freeze Rows and Columns in Excel to Lock in page.

	Merge Cells -- How to merge cells or combine cell values in Excel. How to unmerge cells, avoid merged cell problems. Formula to combine cell text. Videos, Excel files. Details on the How to Merge Cells or Combine Cells in Excel page.
	Print Tips -- Easy steps show how to fix Excel printing problems. Fit all columns on page, repeat headings all pages, print gridlines, remove big gray Page 1 on sheet. Details on the Excel Worksheet Printing Tips - Printing Problem F page.
	Comment Tips -- Excel yellow pop-up comment tips. Add pop-up picture, fix user name, change comment shape, paste comments only. Ideos, sample files, easy written steps. Details on the Comments Tips and Tricks page.

	Comments -- How to insert Excel comments, display or hide comments, format and print Excel comments. Details on the How to Insert, Hide, Format Excel Popup Comments page.
	Objects -- How to quickly select and delete one or more objects on Excel worksheet. See list of hidden objects on sheet copied accidentally. Macro to delete all shapes. Details on the Excel Worksheet Objects Find Select Delete page.
	Error -- How to fix Excel error, Cannot Shift Objects Off Sheet or Can't push objects off sheet. Simple shortcut, or make small change to comments. Video, written steps. Details on the Excel Error Cannot Shift Objects Off Sheet page.

Structure - Templates

These tutorials have Excel templates that you can use at work, or at home!.

Excel Files -- Download free Excel Files and Excel Templates from Contextures. Data validation, formulas, pivot tables, charts, time-saving macros, +more. 100s of files! Details on the Excel Sample Files and Templates page.

	Survey -- Excel survey template examples. Quickly create list of questions, use checkboxes or option buttons for question responses. Videos, free Excel files. Details on the Excel Survey Templates page.
	Budget -- Excel budget template workbook. Enter budget forecast and actual amounts. Formulas calculate variance, chart shows year to date totals, forecast and actual. Details on the Budget Template Forecast vs Actual page.
	Printable Planner -- Get this free Excel weekly planner template. Enter week start date, customize calendar settings, then print weekly planner sheet, to use for the week. Details on the Printable Weekly Planner Template page.

	Weight Tracker -- Easy to use, free Excel weight loss tracker. Enter target weight, weekly weight in pounds, kilos or stone. Check BMI. Line chart shows weekly progress. Details on the Excel Weight Change Tracker page.
	Calories -- Track daily food calories in Excel calorie counter. Enter target calories each day, select food from drop down lists. Add your recipes to calculate calories. Details on the Calorie Counter page.
	Food Tracker -- Use this free workbook to analyze data from your LoseIt food tracker app. How to get your data, and create custom reports. Details on the Excel Food Tracker Reports page.

	Meal Planner -- Get this free Excel weekly meal planner. Select new recipes or choose family favs, plan your daily meals, create weekly shopping list and print the list. Details on the Weekly Meal Planner page.
	Dinner -- Get free Excel chicken dinner cook time planner for Julia Child roast chicken. Enter meal time, chicken weight. List shows start and end time for each step. Details on the Chicken Dinner Planner page.
	Holidays -- Excel templates for shopping lists, gift plans, holiday budget, dinner schedule, calendar, party games, Advent calendar, Christmas trees. Videos, workbooks. Details on the Excel Holiday Templates page.

	Holiday Planner -- Excel holiday planner for gift list, holiday spending budget, task tracking, dinner planning, calendar and more. Plan Christmas, Thanksgiving, other holidays. Details on the Excel Holiday Planner page.
	Holiday Dinner -- Excel Holiday Dinner planner. Enter dinner time and food items to create a preparation schedule, with start times calculated for each step. Details on the Holiday Dinner Planner page.

	Christmas -- Use these free Excel Advent Calendar workbooks to count down the days until Christmas. Choose a macro or no-macro version. Details on the Excel Advent Calendars page.
	Excel Games -- Fun with Excel games- Monopoly, Battleship, Concentration, Treasure Hunt, BlackJack, Easter Eggs. Print Bingo cards, word guess, word search, timeline game. Details on the Excel Games Templates page.

Get Monthly Excel Tips!

Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.

Next, when you get my reply, please click the Confirm button. I add this step to protect you from spam!

Excel Topics