Excel - Tips

Excel

Page update date :
Page creation date :

Contains tips related to Microsoft Excel.

Always display the contents of the specified line on each page when printing in the header

Always display the contents of the specified line on each page when printing in the header

Describes how to display the text and layout of the specified line in the header (top) of each page, even if you print over multiple pages.
Automatically set the height of a line for wrap text

Automatically set the height of a line for wrap text

Describes how to automatically adjust the height of a row of text in a cell when it is displayed in a wrap view.
Disable the automatic hyperlink feature for URLs that you type

Disable the automatic hyperlink feature for URLs that you type

Describes how to prevent hyperlinks from connecting automatically.
Display the Development tab to enable form placement and VBA program development

Display the Development tab to enable form placement and VBA program development

Learn how to add development tabs to the ribbon to enable those features.
Draw a border at the bottom of the page on a page-by-page basis in a macro

Draw a border at the bottom of the page on a page-by-page basis in a macro

Describes how to use macros to automatically draw borders at the bottom of every page.
Reverse the + orientation of grouping in Excel

Reverse the + orientation of grouping in Excel

When grouped in Excel, it reverses the position of the + icon used for folding display.
Scroll by fixing the head of a row or column

Scroll by fixing the head of a row or column

Describes how to scroll through column and row headers so that they can be viewed in a fixed state.
Automatically set a border on the bottom line of a page break when printing in Excel (Conditional Formatting)

Automatically set a border on the bottom line of a page break when printing in Excel (Conditional Formatting)

Learn how to set up excel if you want to automatically draw a line at the bottom of each page when you print.
Reduce screen flicker while macro is running

Reduce screen flicker while macro is running

You'll find a flicker in the screen when you're running a macro, but learn how to keep it down.
Find out which version of Excel is installed in the .NET Framework

Find out which version of Excel is installed in the .NET Framework

A program that checks for the version of Excel that is installed.
Hide the paste options that appear after you paste a value into a cell in Excel

Hide the paste options that appear after you paste a value into a cell in Excel

Describes how to hide the paste options that appear after you paste a value into a cell in Excel.
Unformat as a table in Excel

Unformat as a table in Excel

Describes how to unformat a table in Excel that you want to use in a range cell.