QUESTION : In a source sheet I have values: I want to insert Apple value from source sheet into a […]
Tag: microsoft-excel-2013
Why does Ctrl-Down Arrow in Excel take me to row 1048576?
QUESTION : When I use Ctrl-Down Arrow in Excel 2013 (as described in Go to last line with data, Excel […]
Excel – shortcut to get me back after clicking a link
QUESTION : I have an Excel document that has more sheets and those sheets link to each other using textual […]
How do I extending a formula without dragging across the entire range to extend over?
QUESTION : How can I extend a formula from, for example, cell A1 to A500 without dragging it the whole […]
How to fill sequence in Excel from ranges given in another sheets?
QUESTION : I have an Excel sheet where two columns (say J and K) among data in sheet1 are as […]
How to give duration in excel or libre calc?
QUESTION : I have duration data like 5:23, etc… in m:ss format. I already typed the data, but I cannot […]
Excel if/then formula
QUESTION : I am wondering if there is an if/then formula for the following situation. I am trying to populate […]
Excel when connected to external data: “We found a problеm with some content in [file]”
QUESTION : I have created a spreadsheet in Excel 2013 that gets data from a CSV file, then made a […]
Excel 2013. Address from Value
QUESTION : I have two spreadsheets, one with a Calendar, and the other one with Data Chart. I’m trying to […]
How to link a cell from one spreadsheet to another, dependent on the details in another cell.
QUESTION : I have a workbook with two sheets in. To simplify: On the first sheet I have a unique […]