• Home
  • Akiko Yokoyama
  • Contact
  • Feed
ja | en |

Excel Tips vol.1

Referencing one cell up

This is useful when you need a series of cells in a category.

1
=INDIRECT(ADDRESS(ROW()-1,COLUMN()))

Add +1 to the number in the cell above it

When you want to create a sequential numbered line from No.1 to 100

1
=MAX(INDIRECT(ADDRESS(1,COLUMN())&":"&ADDRESS(ROW()-1,COLUMN())))+1

Add a line break in a sentence.

Use char(10) for line feed code and & for string concatenation.

1
="Add a line break to this sentence" & char(10) & B5
user-image
Akiko yokoyama in Coding
2 minute read

Similar Posts

Actually Made This Blog Multilingual Three Years Ago

Review of the Leica Q2

Re-Builded the Blog with Jekyll + Netlify + Github

Setup for WSL / Windows Subsystem for Linux + Ubuntu

Setting hubot adapter slack & chatwork

user-image

Published Jan 22, 2019

Akiko yokoyama in Coding

Also found in

  • Coding

Share this article

Actually Made This Blog Multilingual Three Years Ago

Review of the Leica Q2

Re-Builded the Blog with Jekyll + Netlify + Github

Setup for WSL / Windows Subsystem for Linux + Ubuntu

Setting hubot adapter slack & chatwork

How to install and setting hubot

  • Home
  • Akiko Yokoyama
  • Contact
  • Feed