Buku kerja Excel terbuka, tapi Anda tidak bisa melihatnya! Bilah tugas mengatakan buku kerja terbuka, tapi tidak ada di layar. Ini baru-baru ini terjadi pada saya ketika saya membuka buku kerja yang terakhir saya buka tiga tahun lalu ketika saya memiliki monitor kedua.
Menonton video
- Ini mungkin terjadi di Excel 2013 atau yang lebih baru: Anda membuka buku kerja di Excel.
- Buku kerja tidak terlihat. Ini ada dalam daftar View, Windows.
- Tapi Anda tidak bisa melihatnya.
- Entah bagaimana… buku kerja itu terakhir disimpan ketika saya memiliki dua monitor.
- Buku kerja mengingat posisinya di suatu tempat di monitor kedua.
- Tapi saya tidak punya dua monitor lagi.
- Gunakan Tampilan, Jendela untuk beralih ke buku kerja lain
- Kemudian, tahan tombol Windows dan tekan panah kiri atau kanan.
- Win + Left Arrow akan memindahkan aplikasi kembali ke bagian kiri layar.
Transkrip Video
Pelajari Excel dari Podcast, Episode 2094: Buku Kerja Terbuka Tapi Tidak Terlihat
Hey, today's question is sent in by me. This happened a couple of days ago, I opened a new workbook: File, Open and the workbook opened. It appeared to open fine except I couldn't see it. And it wasn't this weird problem where I have a blank workbook down in the Status Bar. Down in the Status bar, the Task bar is actually showing me both workbooks are down there. I just simply couldn't see it. And if I would go to View and Switch Windows, right - there it is but it was never opening up.
And I finally realized that this workbook had not been opened for a couple of years and the last time that I opened this workbook, I owned two monitors. I had dual monitors on this computer and that somehow, that other workbook was sitting over on the second monitor that's no longer there. Alright, and I had used some VBA to get the .Left and .Top of the window back where I could see it. But here's a great trick, if you have the Flying Windows key. So on your keyboard between the left Ctrl and the left Alt, you might have the Windows key. If you hold down the Windows key and press the Left Arrow, it will bring the active window back into view; or Windows Right Arrow will move it to the right half of the screen. So either Windows Left or Windows Right will bring it back. So, just a quick little tip today. I guess it’s really now an Excel trick, it’ll work with any apps at all.
Nah, itu sangat singkat. Bahkan tidak perlu membungkusnya, cukup tombol Windows dan Panah Kiri atau Panah Kanan untuk menampilkan kembali aplikasi yang hilang.
Unduh berkas
Unduh file contoh di sini: Podcast2094.xlsm
