Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 27th 09, 09:44 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
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  
Old March 27th 09, 10:40 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
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 can I make a drop down box visible within a worksheet? skittles_golf Excel Worksheet Functions 41 July 12th 17 01:37 PM
How do I make one column or row always visible? Ao Excel Discussion (Misc queries) 7 May 2nd 07 11:13 PM
how do I make rows and columns appear when I print a spreadsheet Debbie Excel Worksheet Functions 3 November 17th 05 01:08 PM
Autoshapes not visible on spreadsheet but visible in print preview John Excel Discussion (Misc queries) 3 February 11th 05 10:23 PM
better search: "make worksheet visible" christo Excel Discussion (Misc queries) 1 December 1st 04 12:20 AM


All times are GMT +1. The time now is 09:27 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017