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 […]