Search results

Dear Excel ninjas, I have to trace excel formula =A1 in spread sheets mostly. I can easily go to normal linked cell address using Ctrl+[ but when my colleague use indirect function like =INDIRECT(ADDRESS($A2,I$1,,,$A$1)), i can not go directly on linked address. is there any short way to go...

Hello ninjas, when i open my file, a popup msg 'unable to open' appears on my screen. i have to click OK for more than 15 times which takes 4-5 mins to let me in. i go to edit links but i can not see any external link there. how i can break & deactivate the external collaboration links in an...

Dear Excel masters, i have data with sales location wise. i just need to show positions (1,2,3...) on the basis of maximum sales. i have uploaded file on below link. kindly advise how i can position them on yellow highlighted format...

Dear all, I am facing a magical excel formatting error and could not fix it. the case is, i have a file with more than 10 excel sheets, after some formatting on those sheets, i had closed the file clicking on save button. on reopening the file, the file will show u that there was no...

Dear i have to work in 10 standard sheets simultaneously. can you help me to Freeze 10 grouped sheets in one attempt? Thanks Hafiz Mudassar

Dear all, Please help me to show business results in graph format as mentioned in below file. http://www.2shared.com/document/ppQTLQ8O/Graph_sample_required.html Thanks, Hafiz Mudassar

Dear all, When I hide unnecessary columns of my workbook, i received below message. please guide. "Cannot shift objects off sheet" Thanks, Hafiz Mudassar

Dear All, Please help me to understand what is the difference in between Indirect Farmula & direct link reference? thanks Hafiz Mudassar

Dear all, I have more 500 rows, 12 column for 12 months, 5 XL sheets for different locations. Each Row contains different farmula like:- - vlookup - subtotal & - sum on end of each month, the rows contain Vlookup func. need to be copy, pasted as values. how i can select & give command...

Dear Guys, Sparklines is not active in my excel 2010. how can i use it? Hafiz Mudassar

Dear, can excel highlight the "lazy dog" in a cell, if we search text by using CTRL+F? like, if A1 cell contains "A quick brown fox jumps over the lazy dog". then "lazy dog" should be highlighted if search command given. Thanks Mudassar

Please guide me what is the keyboard shortcut to go for subtotal options i.e. 1 2 3 Thanks Hafiz Mudassar

Sparkline in my excel 2010 ribbon is not active. how i can activate sparkline? Thanks, Hafiz Mudassar

Dear chandoo, I have been forwarded an excel file containing multiple images, which create file size larger. i want to delete all images in one go. i tried to select all images using seletion pane, but not succeeded. can you help me plz?