To center a range of cells on a printed page in Excel automatically, execute the following steps.
1. On the File tab, click Print.
2. Click ‘Custom Margins’ from the Margins drop-down list.
3. Next, check horizontally and vertically.
4. Click OK.
Worked Examples
- IFERROR function: Description, Usage, Syntax, Examples and Explanation
- How to generate random times at specific intervals in Excel
- RADIANS function: Description, Usage, Syntax, Examples and Explanation
- WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
- Excel Data validation allow numbers only
- Group numbers with VLOOKUP in Excel
- SQRT function: Description, Usage, Syntax, Examples and Explanation
- Count cells that begin with in Excel
- Sum every n rows in Excel
- F.DIST.RT function: Description, Usage, Syntax, Examples and Explanation
Online Excel Courses Outline — Free
Excel For BeginnersHow To Filter Data in Excel
Excel Intermediate
Excel Advanced
*GETTING STARTED WITH EXCEL
- Starting Excel Using Windows 7 (Or Previous Versions)
- Working with and Understanding Excel Ribbon
- Excel Ribbon: Navigation, Customizing, Collapsing and All You Need To Know
- Creating and Opening an existing file in Excel Workbook
- Close and Open Excel Workbooks Through VBA
- Convert an Excel File to PDF
- Save file in 97-2003 Format
- AutoRecover file that was never saved in Excel
- How to share Excel data with Word documents and other files
- Selecting The Blank Worksheet Template
- The Excel Cell Referencing System
- Entering Numbers And Text
- Default Text And Number Alignment
- Summing A Column Of Numbers
- Entering A Date
- Worksheets And Workbooks
- Saving A Workbook To Your Hard Disk
- Closing A Workbook
- Creating A New Workbook
- Opening A Workbook
- Switching Between Workbooks
- Saving A Workbook Using Another Name
- Saving A Workbook Using A Different File Type
- Getting Help Within Excel
- Searching For Online Help
- Alt Key Help
*EXCEL SELECTION TECHNIQUES
- Why Are Selection Techniques Important?
- Selecting A Cell
- Selecting A Range Of Connecting Cells
- Selecting A Range Of Non-Connecting Cells
- Selecting The Entire Worksheet
- Selecting A Row
- Selecting A Range Of Connecting Rows
- Selecting A Range Of Non-Connected Rows
- Selecting A Column
- Selecting A Range Of Connecting Columns
- Selecting A Range Of Non-Connecting Columns
- Recommended Techniques When Creating Or Editing Lists
*MANIPULATING ROWS AND COLUMNS WITHIN EXCEL
- Select, Insert, Rename, Move, Delete Worksheets in Excel
- How to Delete Cells, Row and Rows in Excel
- How to Insert Cells, Row and Rows in Excel
*MANIPULATING CELLS AND CELL CONTENT WITHIN EXCEL
*EXCEL WORKSHEETS
- Switching Between Worksheets
- Renaming A Worksheet
- Recommended Techniques With Naming Worksheets
- Inserting A New Worksheet
- Deleting A Worksheet
- Copying A Worksheet Within A Workbook
- Moving A Worksheet Within A Workbook
- Copying Or Moving Worksheets Between Workbooks
*FONT FORMATTING WITHIN EXCEL
- Font Formatting Options
- Font Type
- Font Size
- Bold, Italic, Underline Formatting
- Cell Border Formatting
- Formatting The Background Colour
- Formatting The Font Colour
*ALIGNMENT FORMATTING WITHIN EXCEL
- Alignment Options
- Horizontally Aligning Contents In A Cell Range
- Centering A Title Over A Cell Range
- Cell Orientation
- Text Wrapping Within A Cell
- Aligning Cell Contents Vertically
- Format Painter
*NUMBER FORMATTING WITHIN EXCEL
- Number Formatting
- Decimal Point Display
- Applying And Removing Comma Style Formatting (To Indicate Thousands)
- Currency Symbol
- Date Styles
- Percentages
- Creating Formulas
- The Easy Way To Create Formulas
- Copying Formulas
- Operators
- Using Operators In Formulas
- Formula Error Messages
- Relative Cell Referencing Within Formulas
- Absolute Cell Referencing Within Formulas
*EXCEL FUNCTIONS
- What Are Functions?
- Common Functions
- Sum Function
- Average Function
- Max Function
- Min Function
- Count Function
- The Counta Function
- The Countblank Function
- What Are ‘If Functions’?
- Using The If Function
*EXCEL CHARTS
- Inserting A Column Chart
- Inserting A Line Chart
- Inserting A Bar Chart
- Inserting A Pie Chart
- Resizing A Chart
- Deleting A Chart
Miscellaneous
- How to Create Gantt Chart in Excel
- How to Create Area Chart in Excel
- How To Create Pareto Chart in Excel
- How to create a Histogram in Excel
*CHART TITLE OR LABELS
- Changing The Column, Bar, Line Or Pie Slice Colours In A Chart
- Modifying The Legend Fill Colour
- Changing The Chart Type
- Modifying Charts Using The Design Tab
- Modifying The Chart Title
- Modifying The Chart Axis
- Modifying The Chart Legend
- Modifying Chart Data Labels
- Displaying Chart Data Tables
- Modifying Chart Gridlines
- Copying And Moving Charts Within A Worksheet
- Copying And Moving Charts Between Worksheets
- Copying And Moving Charts Between Workbooks
*CUSTOMISING EXCEL
Modifying Basic Excel OptionsExcel Intermediate
Have Fun Learning Microsoft Excel Level 2
Excel is the most powerful tool to manage and analyze various types of Data. This tutorial covers in-depth lessons on how to use various Excel formulas, Tables and Charts for managing small to large scale business process.*EXCEL SETUP & PRINTING ISSUES
- Worksheet margins
- Worksheet orientation
- Worksheet page size
- Headers and footers
- Header and footer fields
- Scaling your worksheet to fit a page(s)
- Visually checking your calculations
- Displaying gridlines when printing
- Printing titles on every page when printing
- Printing the Excel row and column headings
- Spell checking
- Previewing a worksheet
- Viewing workbooks side by side
- Zooming the view
- Printing options
- Setting the number of copies to print
- Selecting a printer
- Selecting individual worksheets or the entire workbook
- Selecting which pages to print
- Print Page Numbers in Excel
- Single or double sided printing
- Collation options
- Clear print area in Excel Worksheet
- Page orientation
- Paper size
- Margins
- Scaling
- Printing
*FUNCTIONS AND FORMULAS
- Getting help with functions
- Nested functions
- Consolidating data using a 3-D reference sum function
- Mixed references within formulas
*TIME & DATE FUNCTIONS
- Inserting the current time and date
- Today function
- Now function
- Day function
- Month function
- Year function
*MATHEMATICAL FUNCTIONS
*LOGICAL FUNCTIONS
*MATHEMATICAL FUNCTIONS
*STATISTICAL FUNCTIONS
9 Mathematical Computations Example using Excel Statistical Function*TEXT FUNCTIONS
- Left function
- Right function
- Mid function
- Trim function
- Concatenate function
*FINANCIAL FUNCTIONS
*LOOKUP FUNCTIONS
*DATABASE FUNCTIONS
*EXCEL NAMED RANGES
- Naming cell ranges
- Removing a named range
- Named cell ranges and functions
*EXCEL CELL FORMATTING
- Applying styles to a range
- Conditional formatting
- Conditional Formatting Rules in Excel
- Conditional Formatting New Rule with Formulas in Excel
- Managing Conditional Formatting Rules in Excel
- Conflicting Multiple Conditional Formatting Rules in Excel
- Conditional Formatting Data bars Examples in Excel
- Conditional Formatting Icon Sets Examples in Excel
- Highlight rows with blank cells in Excel
- Highlight values between in Excel
- Custom number formats
MANIPULATING WORKSHEETS WITHIN EXCEL
- Copying or moving worksheets between workbooks
- Splitting a window
- Hiding rows
- Hiding columns
- Hiding worksheets
- Un-hiding rows
- Un-hiding columns
- Un-hiding worksheets
EXCEL TEMPLATES
- Using templates
- Creating Excel templates
- Editing Excel templates
PASTE SPECIAL OPTIONS WITHIN EXCEL
- Using paste special to add, subtract, multiply & divide
- Using paste special ‘values’
- Using paste special transpose option
Excel Advanced
*PIVOT TABLES
Understanding Pivot Tables in Excel- Creating and using a pivot table
- Filtering and sorting data within a pivot table
- Automatically grouping data in a pivot table and renaming groups
- Manually grouping data in a pivot table and renaming groups
*INPUT TABLES
- One-input data tables
- Two-input data tables
*CHARTS
- Creating a combined line and column chart
- Adding a secondary axis to a chart
- Changing the chart type for a particular data series
- Adding a data series to a chart
- Removing a data series from a chart
- Re-positioning chart title
- Re-positioning the chart legend
- Moving and formatting chart data labels
- Modifying chart axis scales
- Formatting an axis to display using commas
- Inserting images into chart columns
- Inserting images to chart bars
- Formatting the chart plot area using a picture
- Formatting the chart area using a picture
*HYPERLINKS
- Inserting a hyperlink
- Editing a hyperlink
- Removing a hyperlink
*LINKING & EMBEDDING
- What is embedding and linking?
- Linking data within a worksheet
- Linking cells between worksheets within a workbook
- Linking data between workbooks
- Linking data from Excel to a Word document
- Linking an Excel chart to a Word document
- Updating, locking and breaking links
*IMPORTING TEXT FILES
- What is a delimited text file?
- Importing a delimited text file
*SORTING AND FILTERING DATA
- Sorting data by multiple columns at the same time
- Applying a pre-installed custom sort
- Creating a customized list and performing a custom sort
- Removing a customised list
- Using AutoFilter
- Using AutoFilter to perform multiple queries
- Top 10 AutoFilter
- Removing all AutoFilters from a worksheet
- Advanced filter criteria
- Sub-totalling
- Removing subtotals
- Expanding and collapsing outline detail levels
*TRACKING AND REVIEWING CHANGES
- Enabling or disabling the ‘track changes’ feature
- Sharing, comparing and merging worksheets
*SCENARIOS
- Scenario manager
- Scenario summary reports
*VALIDATING
Prevent invalid data entering in specific cells Prevent invalid data entering in specific cells How To Create Drop-down List in Excel How to Create Dependent Drop-down Lists in Excel Prevent invalid Product Codes or ID Numbers in Excel Prevent Duplicate Entries in Excel Reject Invalid Dates in ExcelExcel Data validation allow numbers only- Data validation – whole number
- Data validation – decimal number
- Data validation – list
- Data validation – date
- Data validation – time
- Data validation – text length
- Customising a validation input message and error alert
- Removing data validation
*AUDITING
- Tracing precedent cells
- Tracing dependent cells
- Identifying cells with missing dependents
- Showing all formulas in a worksheet, rather than the resulting values
- Inserting and viewing comments
- Editing and deleting comments
- Showing and hiding comments
*MACROS
- Macro to change the page set-up
- Macro to apply a custom number format
- Macro to format a cell range
- Macro to insert fields into the header or footer
- Assigning a macro to a button on the quick access toolbar
- Deleting macros
*PASSWORDS & SECURITY ISSUES
Steps To Password Protect a Workbook in Excel Protect and Unprotect Worksheet in Excel How to Protect and Unprotect Workbook in Excel Make Workbook Read-only in Excel- Adding ‘open’ password protection to a workbook
- Adding ‘modify’ password protection to a workbook
- Removing an ‘open’ password from a workbook
- Removing a ‘modify’ password from a workbook
- Password protecting cells and worksheets
- Hiding formulas
- Un-hiding formulas