98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel
Excel
Resolved · Low Priority · Version Standard
Aneta has attended:
Excel Intermediate course
Excel Advanced course
Excel
When you hide some columns on the worksheet and then copy the remaining data you see to another workseet, hidden colums turn up as well! How to copy the data without the hidden colums?
RE: excel
Copy everything and go to paste and paste special. Select column widths first. No data will appear, but the column widths will all be the same. Paste again and this time the data will show. All data will still be there, but it will still be hidden. No way round this, if you dont want all the collumns then use the Ctrl key - hold it down when you are copying the columns to select only the required columns
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Use the Format Painter to copy formatting more than once in ExcelThe format painter tool provides a quick and easy way to copy formatting from one cell to another in Word. |