Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

If you want to print something from excel and you want to repeat the first top columns, which function of Excel you would use?

user-image
Question added by Nikko Gural , Procurement Office - Commercial Department , Romeo Interiors LLC
Date Posted: 2015/12/28
Rashid Altaf
by Rashid Altaf , Logistics Manager , Bilfinger

use Page Layout TAB --- Print Title  select Row or Column range (row repeate at top or column to repeate at left) which you want repeate on page

MUHAMMAD NOUFAL MARKASSERI
by MUHAMMAD NOUFAL MARKASSERI , Finance Manager , AGS Logistics LLC

Select Print titles from Page Layout menu and then selct range of rows in the "Rows to repeat at top"

Anne Margaret Dias
by Anne Margaret Dias , Accountant , Salad Creations,Al Kulaib National Group Company ,Kuwait

view>freeze panes>freeze top row/first coloum

Afsha Syed
by Afsha Syed , Program Coordinator , S P Jain School of Global Management

i will use the function repeat columns

More Questions Like This