SpreadsheetsDirect

 
Member Since July 7, 2008 , From Southport, United Kingdom
http://www.spreadsheetsdirect.com/
Ask
Liked this profile? Tell your friends about it

Recent Activity by SpreadsheetsDirect

Answered: Excel help

An IF statement allows you to enter a logical test. The format is =if(x equals certain criteria,do this, if not do this). So if A1 = Hello and in B1 you put =if(A1="hello","Hi","") you will get Hi in ...

Commented: About SpreadsheetsDirect's answer

try http://www.homeandlearn.co.uk/me/mes9p1.html

Answered: Answer today!

You use $ to lock the cell ref e.g. $A$1. If you just want to lock the column do $A1, for row do A$1.

Answered: Drag option is not working in excel 2007

Click the Office button top left next to the save icon then Excel Options. Click on Advanced options and in Editing Options make sure Enable fill handle and cell drag-and-drop is ticked.

Answered: EXCEL: Automatic Range Assignment

It's possible but not the easiest thing to explain. You need a table of the upper range numbers with the range descriptions against them. Then you need to use the OFFSET & MATCH functions to find ...

Answered: Saving excel report without all the columns and ...

You can hide unwanted columns/rows by highlighting them, right clicking with the mouse and choosing Hide from the options. If you just want to print a certain area, highlight the area (keep left ...

Answered: Automatically exchange rate update in Excel

If you've got a website with the exchange rate on you can use the Get External Data From Web function. In 2007 go to the Date tab, in Get External Data click the From Web button and enter the url of ...

Answered: Date time stamp subtracing in excel

If you have the old date/time in cell A1 and new in A2 put =(A2-A1)*24*60, change format to General and you'll get the total minutes. Take the *60 off to get hours or add *60 to get seconds.

Answered: Sorting in an excel macro

It does, try recording a macro and doing a sort then you'll get the correct code for the macro.

Answered: Lost sheets in my spreadsheet and date not entered ...

If you right click on the sheet tabs at the bottom you should see Unhide as an option. If you have hidden sheets it will be blue, click it and select the sheets to unhide. For the date go to Format ...

Activity Summary

Topics of Interest

Contacts

SpreadsheetsDirect has no contacts.

Compliments

No compliments were posted on SpreadsheetsDirect's profile yet.