If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
i am having issues with a report in excel. the formatting of the sheet makes it so some of the columns do not display all of the data (ie not autofitted) and the sheet contains 31 pages. is there a way to set by default all columns to always auto-fit in excel... or do i have to select each column on each sheet and go to format -> column -> autofit.
Hmmm, I kinda know what you are talking about. I know if you double click the part on the column that will let you expand or close the width of the column it will auto fit. This will make it a little quicker but I am sure there is another way.
Hit Ctrl A to select all the data and THEN do what he said i.e.
Originally posted by losehlertx13
double click the part on the column that will let you expand or close the width of the column it will auto fit. This will make it a little quicker but I am sure there is another way.
See attached,
that will auto expand the width of the cells to fit the data posted in the largest cell
Jib says:
he isnt worth the water that splashes up into your asshole while you're shitting
Originally posted by ace_dl
Guys and Gals, I have to hurry/leaving for short-term vacations.
I won't be back until next Tuesday, so if Get Carter is the correct answer, I would appreciate of someone else posts a new cap for me
right i knew that... but it still involves going through each sheet of the spreadsheet and doing that... is there not a setting that will make it automatic?
wait, you said 31 pages or 31 worksheets ? If its worksheets, do the following
- click on the first worksheet (tab at the bottom),
- Press and hold the shift key
- then click on the last work sheet (all the time keeping the shift key depressed).
- All worksheets should now be selected.
- Then do the above
If that doesnt work, do all the above except for the last step, do Format >> Rows >> Autofit
Jib says:
he isnt worth the water that splashes up into your asshole while you're shitting
Originally posted by ace_dl
Guys and Gals, I have to hurry/leaving for short-term vacations.
I won't be back until next Tuesday, so if Get Carter is the correct answer, I would appreciate of someone else posts a new cap for me
if you select all sheets than do ctrl A in one of them, you'll select all cells of all sheets.
then do click right and select "format cell"
select alignment then "wrap text" you can also center horizontal or vertical
cheers
If the doors of perception were cleansed, every thing would appear to man as it is: infinite. - William Blake
you can also make a macro to run at specified events to do this, and can save it globally or only for the spreadsheet (in case it's pulling from an ODBC source or something). events like any time a cell is changed, etc
Jib says:
he isnt worth the water that splashes up into your asshole while you're shitting
Originally posted by ace_dl
Guys and Gals, I have to hurry/leaving for short-term vacations.
I won't be back until next Tuesday, so if Get Carter is the correct answer, I would appreciate of someone else posts a new cap for me
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.
Tweet
Comment