Make the table floating on an Excel sheet.
Solved
Richyao
-
Richyao -
Richyao -
Hello,
here is my issue. On an Excel sheet, I have my main table for restaurant management, next to it I created another small table to display the daily consumption of customers. So basically, over the month, I can see what customer X consumed, for example, on the 2nd or 16th of the month and how many times. Since the main table is long, I would like to make the small table next to it floating so that I can see it at each level on the page, regardless of scrolling. Like making it fixed while still being able to modify it.
Well, I hope I have explained my problem.
Thank you for the answers.
Configuration: Windows / Chrome 65.0.3325.181
here is my issue. On an Excel sheet, I have my main table for restaurant management, next to it I created another small table to display the daily consumption of customers. So basically, over the month, I can see what customer X consumed, for example, on the 2nd or 16th of the month and how many times. Since the main table is long, I would like to make the small table next to it floating so that I can see it at each level on the page, regardless of scrolling. Like making it fixed while still being able to modify it.
Well, I hope I have explained my problem.
Thank you for the answers.
Configuration: Windows / Chrome 65.0.3325.181
1 réponse
Hello,
By taking a picture of your table with the camera (the data is updated in real time in your image):
https://forums.commentcamarche.net/forum/affich-37641916-excel-l-outil-appareil-photo-sous-excel
then you can move your image manually or with a VBA code to be put in the module of the relevant sheet by pressing Alt F11 to access it:
There you go
--
@+ The Pivert
By taking a picture of your table with the camera (the data is updated in real time in your image):
https://forums.commentcamarche.net/forum/affich-37641916-excel-l-outil-appareil-photo-sous-excel
then you can move your image manually or with a VBA code to be put in the module of the relevant sheet by pressing Alt F11 to access it:
Option Explicit Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim ecran Set ecran = ActiveWindow.VisibleRange With ActiveSheet Shapes("Image 1").Left = ecran.Left + 200 ' adapt the image name and dimensions Shapes("Image 1").Top = ecran.Top + 50 End With End Sub There you go
--
@+ The Pivert
Richyao
Ah thank you. I finally did it.