Archive | Microsoft Excel

Excel Interop: Move a Worksheet

Excel Interop: Move a Worksheet

Howdy! I spent an hour or so trying to figure this one out. Hope this helps someone. I am using Excel Interop with C#, and have a method that calls the .Move(Before, After) function on a Worksheet. I was trying to move a sheet to the end, and was using this code: mySheet.Move(null, myWorkbook.Worksheets[myWorkbook.Worksheets.Count]) I […]

Continue Reading 0

C# / VSTO – Using Excel Ranges

Using Visual Studio Tools for Office (VSTO) with Excel lets you use C# (or your other favorite .NET language to leverage the power of Excel. But you will have to learn how the syntax for the Excel object model as opposed to just using VBA syntax. This post shows you how to use Excel ranges […]

Continue Reading

Excel Tip: The Camera Tool – a cool view

Excel’s Camera tool is a really cool, but relatively obscure tool that lets you create a window on your spreadsheet that shows a vignette of a block of cells. The screen clip shown here demonstrates it in action. The Camera tool is pretty well hidden, so the first trick is finding the button to add […]

Continue Reading
Excel Stoplight Chart screenshot

Excel: Scatter chart with Stoplights

My friend Peter strikes again. This time, it’s a very cool take on the scatter chart. Using the Offset function in Excel, you can create a chart that gives you the stoplight dashboard effect. The math behind this is a bit tricky, but it’s all right there in the Excel formulas. Like the scrolling graph […]

Continue Reading
Excel: Scrolling chart screenshot

Excel: Create Scrolling Charts

My friend Peter showed me a very cool method of creating a graph or chart that lets you scroll through the time periods (or your x-axis) using a scroll bar. It involves setting up a few defined ranges containing formulas and using a scroll bar to control the starting point of your x-axis. You configure […]

Continue Reading

Awesome Utilities Add-In for Excel

I stumbled across an awesome utility add-in for excel that will save you tons of time doing mundane little formulas and formattings to your data. The folks over at ASAP Utilities have created this wonderful tool and it’s completely free for the taking. There must be over 100 functions in this add-in, here’s a few […]

Continue Reading

Excel: Turn a Column into a Row and Vice Versa

Just got a call today from an accountant wondering how to turn a column of data into a row. If you don’t know, you’ll love it…so simple: Highlight the cells you want to flip the orientation on Ctrl-C to copy (or copy button…whatever you like) Click Edit/Paste Special (might have to expand your Edit menu […]

Continue Reading

Powered by WordPress. Designed by Woo Themes