Thread: Can we create a viewport in Excel like Autocad?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote