When you opened the excel file other man saved, have you thought “Why didn’t he move cursor to A1 cell” before ? Not to be thought so, conversely, I will introduce the way to move cursor in all sheets to top left, move scroll bars in all sheets to top left and activate first sheet.
Continue reading Excel: Move Cursor in All Sheets to Top LeftTag Archives: Excel
Excel: Prepare to Connect to the Database from VBA
Here’s the way to connect to the database from Excel VBA. (Excel から VBA を使わずにデータを取得・表示する方法もあります。 例: Windows, Excel: データベースから直接値を取得して表示する)
Continue reading Excel: Prepare to Connect to the Database from VBAReaders who viewed this page, also viewed:
Windows, Excel: Connect Database Directly and Show the Data
Here, I introduce the way to show the database records in Excel directly. In this article, I’ll show you the way using ODBC connection. (There are other ways.)
Continue reading Windows, Excel: Connect Database Directly and Show the DataReaders who viewed this page, also viewed:
(日本語) Excel: ピボットテーブルで平均を計算する
LibreOffice Calc: Retrieve Substring from String in Formula
I introduce the way to retrieve substring from string in LibreOffice Calc formula. This way can be also applied for Microsoft Office Excel.
Continue reading LibreOffice Calc: Retrieve Substring from String in Formula
