Skip to main content

Excel Tips: File > View Settings

Default View Settings

Change the font / size of row and column headings in Excel

How to automatically expand formula bar in Excel?

How to change default font in Excel?

How to change default gridline color to others in Excel?

How to change default view in Excel?

How to change or increase font size in formula bar?

How to clear recent document lists from Excel?

How to quickly convert column number to letter?

How to resize worksheet tabs in Excel?

Freeze Panes

How to apply freeze / unfreeze panes to multiple worksheets at once?

How to freeze top and bottom row at once in Excel?

How to keep column header viewing when scrolling in Excel?

How to keep first row always visible in Excel?

How to keep title row moving down with the page (freeze the title row) in Excel?

How to lock specific columns always visible in a sheet or across workbook?

How to make header row follow when scroll down worksheet in Excel?

How to make top row always stay visible in Excel?

How to prevent top row from scrolling in Excel?

How to quickly freeze rows and columns in Excel?

How to repeat rows when scrolling worksheet in Excel?

Manage Windows

How to compare Excel sheets side by side?

How to split a worksheet into multiple panes in Excel?

How to switch between multiple workbooks?

How to switch workbooks in Excel?

How to view two or more worksheets at once in Excel?

Zoom

How to zoom all tabs in one size in Excel?

How to zoom on roll with IntelliMouse in Excel

How to zoom or magnify selected cells in Excel?

How to zoom up or down the cells while clicking at data validation list in Excel?

Others

How to blink or flash text of specified cell in Excel?

How to change sheet tab color based on cell value?

How to change the direction of worksheet?

How to display the active cell in top left in Excel screen?

How to save custom filter criteria/view in Excel?

How to show file path in title bar or toolbar in Excel?

How to switch to full screen in Excel ?