how to select a range diagonally in excel?

excel sap dashboard xcelsius
user1429595 picture user1429595 · Jun 21, 2012 · Viewed 9.5k times · Source

Hi I have a simple question, how to select a range diagonally in excel, lets say I need to select (a3 and b1) or (a3 and b2) or simply a1 and b2 I need this range for Sap dashboard design(xcelsius) and Holding down a control key was NOT an Option!!

Thanks

Answer

Daniel Moura picture Daniel Moura · Sep 19, 2012

You can't select a range diagonally. In your situation I think the best option is to get the range you want and copy to a column using a formula.

For example, if you want to select a1, b2 and c3. In cell d1 put =if(a1="";"";a1), in cell d2 =if(b2="";"";b2) and in cell d3 =if(c3="";"";c3). Then you select d1 to d3.

Related questions

Pulling data from SAP using Excel Macros

So I am trying to pull data from SAP using excel macros. I am new to VBA so please bear with me. I found a topic on here called VBA pulling data from SAP for dummies and I am confused. …

Read More
VBA to call SAP transaction

I am new to SAP and this site. I am trying to call a SAP transaction from Excel, I use many codes from the internet but still a failure. Doesn't matter what code I use, I always get same error …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More