Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how do i make more columns visible in a spreadsheet?

QuickBooks exports an EXCEL SS with a limited number of columns displayed .
I need more columns but amunable to make them visible
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 7
Default how do i make more columns visible in a spreadsheet?

What makes you think that there are columns in the SS that you can not see?
AFAIK, Quickbooks does not hide any columns when you export a report to
Excel. If the columns are included in the Quickbooks report, they should be
visable in the Excel SS. If the column is not included in the report, then
it is not exported. Quickbooks does not always make the SS columns wide
enough to display the data in the column. If that is the case, then select
the column and then select the column and then select Format/Column/Autofit
Selection. The other possibility is that someone has hidden columns after
the export from Quickbooks. If that is the case, select a column to the left
of the hidden column by clicking the column letter in the header row. Then
hold down the shift key and select a column to the right of the hidden column
so that you have the columns on both sides of the hidden column selected.
Then select Format/Column/Unhide. This should unhide the column if the
worksheet has not been protected. If the worksheet is protected, you will
have to unprotect it to unhide the column.

"Haymarket Ed" wrote:

QuickBooks exports an EXCEL SS with a limited number of columns displayed .
I need more columns but amunable to make them visible

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make one column or row always visible? Ao Excel Discussion (Misc queries) 8 April 23rd 23 09:01 PM
How can I make a drop down box visible within a worksheet? skittles_golf Excel Worksheet Functions 42 April 21st 23 02:59 PM
how do I make rows and columns appear when I print a spreadsheet Debbie Excel Worksheet Functions 3 November 17th 05 02:08 PM
Autoshapes not visible on spreadsheet but visible in print preview John Excel Discussion (Misc queries) 3 February 11th 05 11:23 PM
better search: "make worksheet visible" christo Excel Discussion (Misc queries) 1 December 1st 04 01:20 AM


All times are GMT +1. The time now is 07:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"