Microsoft Excel

Working notes on Microsoft Excel: Import, Lookup, Set Column width, and Set Row height.

Microsoft / Wikimedia CommonsPublic domain

Working notes on Microsoft Excel: Import, Lookup, Set Column width, and Set Row height.

Working notes on Microsoft Excel: Import, Lookup, Set Column width, and Set Row height.

Topics

Import

Import: =importrange(\"\", \"<>:<>\").

Lookup

=VLOOKUP(Sheet1!C2,Sheet3!A1:Sheet3!B23,2).

Set Column width

Sub ColumnWidthInCentimeters().

Set Row height

Cell height cannot be resized via GUI.

Updated: 2026 Aug 19