Posts Tagged ‘Efficiency’

Reduce file size and load/save time with .xlsb format

Written by Peter Albert on . Posted in Starter

Executive Summary

Store any Excel 2007+ files as Excel Binary Workbook (.xlsb), instead of the default Excel Workbook or Excel Macro-Enabled Workbook! This will reduce the size of the file significantly (usually by 30-60%!) and with it the load/save time.

To make this the default format, use OptionsSaveSave file in this format and change the dropdown to “Excel Binary Format“.

Detailed description

Powerful shortcuts to change the structure of your worksheet

Written by Peter Albert on . Posted in Shortcuts, Starter

Executive Summary

6 shortcuts will allow you to insert, delete, move, and copy rows or columns with easy. Applying them will make you look like an Excel-pro to your team and client, even if you just started!

Quick reference

Shortcut Functionality
CtrlSpace Select column
ShiftSpace Select row
Ctrlarrow keys Extend selection (to multiple rows/columns)
Ctrl+ Insert
Ctrl- Delete
CtrlX Cut (use together with Ctrl+ to move to new location)

Detailed explanation