Excel How to Insert Values ACROSS not Down 2

[JohnBates]

Hi everyone,

This is Excel 2003.

I will be manually pasting values into a worksheet and I need those values to be inserted in cells across, not down.

Is there a way to set my worksheet to enable this?

Thanks, John

 

[SkipVought]

hi,

Edit > Paste Special -- TRANSPOSE

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[JohnBates]

Thanks, Skip.

I was hopefull but all I see are Paste As: Unicode Text OR Text

 

[JohnBates]

.... more info if it helps.

I'm copying the values from a SQL Server pane, then pasting into the Excel sheet.

I have Excel 2003

Thanks, John

 

[bluedragon2]

Couple of steps, paste into a blank sheet, then copy from there and past as Skip showed.

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[JohnBates]

Thankyou Skip and Blue. Your ideas worked.

I'm retrieving the names of databases on 50 SQL Servers. It just makes sense and helps to be able to insert the database names across, beside the server name.

John

 

[SkipVought]

I'm retrieving the names of databases on 50 SQL Servers. It just makes sense and helps to be able to insert the database names across, beside the server name.

You can IMPORT data from your SQL Server database DIRECTLY from Excel, using Data > Import External Data > New Database Query... You must have a driver configured for the DB of your SQL Server. The Query by Example Grid in MS Query, is somewhat similar to MS Access.


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]