Can we create a viewport in Excel like Autocad?
 

I have a very huge spread sheet and i want to see only some specific areas in
other tabs, something like viewport in autocad, could somebody please help?

Can we create a viewport in Excel like Autocad?
 

Those of us who don't work with Autocad don't know what a "viewport" is,
although we can make assumptions.

By "spreadsheet" do you mean a workbook with multiple worksheets or a workbook
with one worksheet that is "huge"?

If the latter, chack out DataFilterAutofilter to get specific data.

You can create a Custom Views under ViewCustom Views.


Gord Dibben MS Excel MVP

On Wed, 30 Jan 2008 11:17:01 -0800, Alireza Nejad <Alireza
wrote:

I have a very huge spread sheet and i want to see only some specific areas in
other tabs, something like viewport in autocad, could somebody please help?